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

http://www.connectionstrings.com/excel-2007

 

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

http://msdn.microsoft.com/en-us/library/ms140052.aspx