how to import data from excel to sql server using vb.. Thanks
hery 0 Light Poster
Recommended Answers
Jump to PostThis attachment should point you in the right direction. Remeber to add excel to your references. Also check the module for your connection settings.
All 2 Replies
vb5prgrmr 143 Posting Virtuoso
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
AndreRet 526 Senior Poster
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, networking, learning, and sharing knowledge.