Access import specs to bcp import file

Hello all
We have data that we import using access import specs in to Access. But the
data is getting rather large and we would like to switch to our SQL database
and analyze the data there. Is there any way to use the access specs in SQl
server and import the data using bulk insert or bcp. We are talking about
millions of records here and would like to get a time efficient solutions.
We have utilities that create access import specs but nothing that can
create a sql server import spec or a bcp import spec.
ThanksTake a look at the Bulk Insert task in DTS. There is an
option to generate a format file from the source file.
-Sue
On Thu, 31 Mar 2005 16:15:08 -0500, "Rahul Chatterjee"
<rahul@.benesysinc.com> wrote:
>Hello all
>We have data that we import using access import specs in to Access. But the
>data is getting rather large and we would like to switch to our SQL database
>and analyze the data there. Is there any way to use the access specs in SQl
>server and import the data using bulk insert or bcp. We are talking about
>millions of records here and would like to get a time efficient solutions.
>We have utilities that create access import specs but nothing that can
>create a sql server import spec or a bcp import spec.
>Thanks
>