Load Spreadsheet into SQL server using VB or VB.NET

[VBFOXDEV35]

Hello all. I have this simple project to work on and I want to make sure I am going in the right direction.

I have a SQL server table of about 100,000 asset numbers and I want to create an interface to load a spreadsheet to eventually find any matches, then report back to the user the found records.

I am thinking of using ODBC to load the excel data into memory, then create a temp SQL table. To which I use an INNER JOING to search the asset numbers. Then return the findings in a report.

What do you all think is the best method to use? Is there anything in .NET that might save time / resources than using VB 6?

Thanks to all that reply.

Art
Art DeGaetano II
Software Developer, MOUS

 

[CasperTFG]

If your using SQL server with that number of transactions, then I would advise staying away from ODBC. ODBC drivers create CTT temp files which can cripple a system under high loads, and they don't always get cleaned up.

Instead I would suggest ADO. It's jsut as easy, if not easier to use, and so much more powerful.

Craig, mailto:sander@cogeco.ca

Si hoc legere scis, nimis eruditionis habes