User Profile

Collapse

Profile Sidebar

Collapse
Roytop
Roytop
Last Activity: Sep 18 '06, 06:04 AM
Joined: Sep 13 '06
Location: Russia.Moscow
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Roytop
    replied to unspecified error
    in ASP Classic
    The problem is in your SQL query sintax or DB table field type.

    Response.Write( strSQL) before Execute command and paste apeared query into MS SQL Query Analyzer for debugging.
    See more | Go to post

      Leave a comment:

    • Roytop
      replied to Excel transfer to SQL using VB
      in Visual Basic
      Hi!
      Use this little VBA code for uploading Excel data to MS SQL database.

      Sub upload()
      Set connAS400 = CreateObject("A DODB.Connection ")
      connAS400.Open (" Provider=SQLOLE DB.1;InitialCat alog=dbname;Ser ver=servername; UID=user;PWD=pa ssword; ")
      ConnOpenAS400 = True
      connAS400.Comma ndTimeout = 100

      For i = 1 To Workbooks(1).Wo rksheets(1).Use dRows.Count...
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...