codetoad.com
  ASP Shopping CartForum & BBS
  - all for $20 from CodeToad Plus!
  
  Home || ASP | ASP.Net | C++/C# | DHTML | HTML | Java | Javascript | Perl | VB | XML || CodeToad Plus! || Forums || RAM 
Search Site:
Search Forums:
  How to import excel file into sql using visual basic 6  szar28 at 08:05 on Tuesday, September 23, 2003
 

I have a problem in getting an excel file and transfer it directly to sql using visual basic 6. Can you pls help me writing a code that will import excel file into sql. Thank you!

  Re: How to import excel file into sql using visual basic 6  Hun at 02:33 on Wednesday, September 24, 2003
 

As a non programer I went about this in two steps:-)

I create a Mirosoft acess file from my XL sheet by importing directly into access from the XLS sheet.

Then I turn around and export directly into the MySQL database from access.

I couldn't program to save my life but this got me by?



<Added>

As a non programer I went about this in two steps:-)

I create a Microsoft Access file from my XL sheet by importing directly into access from the XLS sheet.

Then I turn around and export directly into the MySQL database from the access database.

I couldn't program to save my life but this got me by?








CodeToad Experts

Can't find the answer?
Our Site experts are answering questions for free in the CodeToad forums








Recent Forum Threads
•  Re: horizontal scroll bar for drop down list box
•  Re: Doubles .toString Error: double cannot be dereferenced.
•  Re: Perl - Read and Write output file
•  Re: spaces between menus. possible?
•  Re: c# .net Exception of type System.StackOverflowException was thrown.
•  Re: Plz its urgent:validation code
•  Re: The Dim appExcel As Excel.Application doesn`t work ????
•  Re: need help with main()
•  Re: onclick thumbnail images in gridview or datalist


Recent Articles
ASP GetTempName
Decode and Encode UTF-8
ASP GetFile
ASP FolderExists
ASP FileExists
ASP OpenTextFile
ASP FilesystemObject
ASP CreateFolder
ASP CreateTextFile
Javascript Get Selected Text


© Copyright codetoad.com 2001-2011