I want to import 3 columns with data from Excel to SQL Server 2000
Any body can help or can give me VB 6 programme. Thanks.
Printable View
I want to import 3 columns with data from Excel to SQL Server 2000
Any body can help or can give me VB 6 programme. Thanks.
Have a look at this tutorial from si_the_geek.
That could actually be the long-winded approach in this case... I recommend taking a look at the articles that are specifically about Excel/SQL Server in our Office Development FAQs (at the top of the Office Development forum)
Are you talking about this question? How do I transfer data from SQL Server to Excel using ADO? If not, which one are you talking about?
That is one of the them - there is another one about SQL Server there too.
yes Mr Big Red . I want a little VB 6.0 programm that could Import data from MS Excel file and then Paste in MS SQL Server 2000 database.
Mr. Dee-U(Post No.2) I have followed the link and read the entire article, it i very difficult kind of programme. Can u please tell me some easy way?