Post reply

from MS Excel to SQL Server?

  • March 6, 2006 at 10:57 am

    #96674

    I know how to place the information in Excel into an Access Database and then take the info now in the Access DB and place it into SQL Server.  Is it possible to eliminate the intermediate step of placing the info in Access? Can i simply go for Excel to SQL Server?

    I was not able to find anything on Microsoft.com about this.

     

    Thanks!

  • March 6, 2006 at 11:31 am

    #624983

    Not exactly sure what information you mean?

    are you simply trying to import data from excel to sql server?

    Use the dts import wizard.

    Or build a dts package.

     

  • March 6, 2006 at 12:24 pm

    #625001

    thanks!

  • March 8, 2006 at 2:00 pm

    #625526

    Jacob,

    Try the following - just change machine name, folder and file name.

    SELECT *

    FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0',

    'Data Source="\\<<machine name>>\C$\temp\accounting.xls";User ID=Admin;Password=;Extended properties=Excel 8.0')...Sheet1$ AS s1

     

    --Steve

  • March 13, 2006 at 1:03 pm

    #626354

    Thanks for the information Steve. I'll take a look at it.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply