how to import data from excel to sql server using vb.. Thanks

Recommended Answers

Answered by vb5prgrmr 143 in a post from

To get started on learning ADO to connect to SQL Server, first create an ODBC DSN (Administrative tools, ODBC Data sources). Next start a new project and use the Data Form Wizard with the options of code to create a form for you. Then, goto

Jump to Post

All 2 Replies

To get started on learning ADO to connect to SQL Server, first create an ODBC DSN (Administrative tools, ODBC Data sources). Next start a new project and use the Data Form Wizard with the options of code to create a form for you. Then, goto http://www.connectionstrings.com to replace the ODBC DSN with a DSN Less connection.

Now, with excel you can also use ADO to access its data or you can use automation. If you search with your friends yahoo/google/bing/ask/answers you should be able to find many different tutorials on both methods.

Good Luck

This attachment should point you in the right direction. Remeber to add excel to your references. Also check the module for your connection settings.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.