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 databas
e
>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
>

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.
Thanks
Take 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
>

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
>

Access Denied on BCP file for push

I setup a snapshot with 2 subscribers I started one push agent - let it
finish - stopped the agent and started the second push agent. The following
error is returned almost immediately...
..........bcp could not be opened. Operating System error code 5(Access
Denied) .........
Any ideas?
You're permissions on the Subscriber is what it sounds like. RClick the
Publisher/ Props/ Replication/ Configure/ Subscribers/ "..." button next to
the Subscriber/ see who you are connecting to the Subscriber as.
"frankm" <frankm@.nospam.postalias> wrote in message
news:u6yL7rKqFHA.3720@.TK2MSFTNGP14.phx.gbl...
>I setup a snapshot with 2 subscribers I started one push agent - let it
> finish - stopped the agent and started the second push agent. The
> following
> error is returned almost immediately...
> .........bcp could not be opened. Operating System error code 5(Access
> Denied) .........
> Any ideas?
>