Re: import accessfiles with stored procedures

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Uri Dimant (urid_at_iscar.co.il)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 16:55:51 +0200

Jason
One option is
INSERT INTO ......
SELECT *
FROM OPENDATASOURCE(
 'Microsoft.Jet.OLEDB.4.0',
 'Data Source="d:\northwind.mdb";
 User ID=Admin;Password='
 )...Customers

"Jason" <jasonlewis@hotrmail.com> wrote in message
news:esocaw2EFHA.3416@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Could somebody tell me how to import access-files to a sql server
database?
>
> I would like to import all tables from access to the temp, do some
> data-manipulation and then insert into a database. I know that dts can
> import, but i want to address the tempdb so i don't have to create
> temptables in my databases.
>
> I hope someone can help me.
>
>