[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