I'm looking for a sample to importa data from a MS Excel file to SQL Server 2005 table, I'm working with an Inventory table (product, sku, price, cost...) the idea is importa the data directly to SQL Server table that of course is user in a SF application.
I already search in Google and MSDN forums but i can fin anything like this, just to open Excel files, and I need to load the data in a table. Hope someone have a small sample?
Kindest regards Everything is possible, just keep trying...
The SQL Wizard is great but not present in the Express edition, I' need the users can import the data. So I need to add some code to the application.
Thanks Everything is possible, just keep trying...
I just did a search on "import excel into sql server vb.net" and got lots of samples. Maybe you could get an idea there.