Importing Excel/Access File - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Importing Excel/Access File

Author

Topic

arv_rehal
Starting Member

4 Posts

Posted - 2009-06-10 : 14:28:12

Hi All,

Any one can help me to know the command for importing excel/access file.

Thanks

Arvinder

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-10 : 14:29:47

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/import-export-to-excel.aspx

arv_rehal
Starting Member

4 Posts

Posted - 2009-06-15 : 08:39:14

Hi All,

I tried to import excel file in sql by this command but i got a error while running...........................

Insert into arvcontactxls Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel8.0;Database=C:\Documents and Settings\arehal\Desktop\arv\Telebriefings (May 20 - June 9, 2009).xls;
HDR=YES', 'SELECT * FROM [directions09$]')

*************** Error Below **************

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.".
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".

Can anyone help me, Thanks

Arvinder

Arvinder

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-15 : 09:02:52

Is this a one-time occurance? See the Import/Export wizard.

E 12°55'05.63"
N 56°04'39.26"

arv_rehal
Starting Member

4 Posts

Posted - 2009-06-15 : 09:14:08

yes one time. i didnt got what to check in import/export wizard

Arvinder

Jas_The_Ace
Starting Member

15 Posts

Posted - 2009-06-15 : 09:26:42

You can do it really easily in Integration Services
Create a new package
Add a data flow task
In the data flow task, add an Excel Source and a and a SQL Server destination

Jason

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-15 : 09:30:08

And that is exactly what the Import/Export wizard is doing...

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources