Hello,
I am a new developer in VB.NET 2003 and i want to import data from an Excel sheet to a database (SQL Server), using a program implemented in VB.NET 2003.
The data need to be processed before i put them in the database, so that i am using VB.NET 2003!
I would be glad hearing from anybody instructions or tips how to "connect" Excel with VB.NET 2003. The sheet that i want to import has to columns and about 2000 records.
What i need to do is:
1.) to read the records from the excel sheet and put them into a list,
2.) make some work on these data and finally
3.) put them into one or two tables in a database.
So, if there are any ideas i am glad hearing them!
Thanks for your time!

hi there..

open it like a database... you can then open a dataset and use it like any other table in a database...

HTH

Gonzalo