Import excel data into database

Dec 19, 2012 at 7:05 AM

Hello Perceiveit,

is there any function to import excel file into database

I have excel file with 50000-100000 rows and 50-100 columns

is there any fasted way to insert excel record into database.

thanks in advance.

Dec 20, 2012 at 6:10 AM

That's really a different capability to what we are trying to do here.

You can connect to excel files with ACE.OLEDB connection string


If you are using SQL Server do it from the Management Studio import export wizard...