Import from file

I am looking for a method to pull the data from several
files in the same directory into a SQL db. I can get DTS
to work for a single file but not multiple files. If
someone has an example, great, if not, where do I start?
Am I in the right place with DTS?
Thanks!
JamesSee if this helps: http://www.sqldts.com/default.aspx?6,103,246,0,1
--
Andrew J. Kelly
SQL Server MVP
"James Wood" <jgwood@.dot.state.az.us> wrote in message
news:09eb01c347f2$02d0c540$a001280a@.phx.gbl...
> I am looking for a method to pull the data from several
> files in the same directory into a SQL db. I can get DTS
> to work for a single file but not multiple files. If
> someone has an example, great, if not, where do I start?
> Am I in the right place with DTS?
> Thanks!
> James|||That is what I was looking for. I will give it a shot!
Thanks!
James
>--Original Message--
>See if this helps: http://www.sqldts.com/default.aspx?
6,103,246,0,1
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"James Wood" <jgwood@.dot.state.az.us> wrote in message
>news:09eb01c347f2$02d0c540$a001280a@.phx.gbl...
>> I am looking for a method to pull the data from several
>> files in the same directory into a SQL db. I can get
DTS
>> to work for a single file but not multiple files. If
>> someone has an example, great, if not, where do I
start?
>> Am I in the right place with DTS?
>> Thanks!
>> James
>
>.
>

import data from excel sheet to sql server

i am using an OPENROWSET method to import from excel data to sql server. i a
m getting an error like
ADO error:[OLE/DB provider returned message: Operation wa canceled.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitializ
Initialize returned 0x80040e4e
Could not initialize data source object of OLE DB provider "MSDASQL'.
Deferred prepare could not be completed
i want to reinstall the OLE DB Driver.can anyone tell me the exact link to d
owload the OLE DB driver.
From http://www.developmentnow.com/g/100...ver-connect.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.comThe provider is installed with MDAC. You can download MDAC
versions and also download component checker to check the
MDAC version from:
http://msdn.microsoft.com/data/ref/mdac/downloads/
The exact link depends on which version you want to
reinstall.
-Sue
On Tue, 01 Aug 2006 10:19:53 GMT, shybi<ajesh@.k.st> wrote:

>i am using an OPENROWSET method to import from excel data to sql server. i
am getting an error like
>ADO error:[OLE/DB provider returned message: Operation wa canceled.]
>OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitializ
>Initialize returned 0x80040e4e
>Could not initialize data source object of OLE DB provider "MSDASQL'.
>Deferred prepare could not be completed
>i want to reinstall the OLE DB Driver.can anyone tell me the exact link to
dowload the OLE DB driver.
>From http://www.developmentnow.com/g/100...elopmentnow.com|||I think you want to be using a different provider instead of "MSDASQL."
Try: Microsoft.Jet.OLEDB.4.0
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"shybi" <ajesh@.k.st> wrote in message
news:13b25c23-b877-4ac8-92dd-2d242c204a77@.developmentnow.com...
>i am using an OPENROWSET method to import from excel data to sql server. i
>am getting an error like
> ADO error:[OLE/DB provider returned message: Operation wa canceled.]
> OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitializ
> Initialize returned 0x80040e4e
> Could not initialize data source object of OLE DB provider "MSDASQL'.
> Deferred prepare could not be completed
> i want to reinstall the OLE DB Driver.can anyone tell me the exact link to
> dowload the OLE DB driver.
> From
> http://www.developmentnow.com/g/100...ver-connect.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com