[AccessD] Sybase SQL export to Access

...absolutely :)

William Hindman

----- Original Message ----- 
From: "Mike & Doris Manning" <mikedorism at verizon.net>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, September 26, 2006 7:51 AM
Subject: Re: [AccessD] Sybase SQL export to Access


>I am interested in this as well, William, as I have a similar project 
>coming
> up.  If you figure it out on your own, please share.  I will do the same.
>
> Doris Manning
> mikedorism at verizon.net
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: Tuesday, September 26, 2006 12:13 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Sybase SQL export to Access
>
> ...I have a client database that uses a Sybase SQL db ...its a single 
> table
> ...I need to export it to a text file or mdb for use in an Access mdb
>
> ...I of course don't have Sybase or access there to else I'd just use the
> bcp utility myself.
>
> ...I played with using the bcp.exe command line utility from SQL Server
> hoping that the sql might be the same as the Sybase SQL bcp.exe utility
> ...but of course it doesn't work.
>
> ...anyone here have the tools to do this? ...or ideas on how I can do it
> myself would be preferable since I'll need to import the data quarterly?
>
> ...if anyone wants to look at the file, e me off line and I'll send you 
> the
> ftp dl instructions ...my host doesn't allow anonymous ftp access.
>
> William Hindman
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>