convert MS access 2000 table to sybase ASE database

[franklinmount]

HI

I have a .dbf file that I imported into MS ACCESS and now need to convert it into a comma delimited file or a format that I can import into Sybase ASE 12.5.

The file is suppose to be in MS FoxPro but I didn't have that applicaton. I instead imported it into MS Access and it open fine. Now I need to have a way to get it into Sybase ASE 12.5.

thanks,

 

[JeanNiBee]

Hi

If you can get the info from the Access file into CSV (Comma delimited format) then you can use the Sybase tool 'bcp' to import it.

bcp can read files to import them, in bulk and very fast, into Sybase.



-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects

 

[franklinmount]

Hi

How can I get a copy of BCP for windows 2000. I am not familiar with the bulk copy program. So I would need to get a hold of some documentation as well.

thanks,

Mario

 

[JeanNiBee]

Hi

bcp is installed when you install the server. If you want to just run the utilities locally to connect to a sybase instance. Download the ASE client.

You can get the developers version of the server and client here. Just fill in the registration form and off you go.

[URL unfurl="true"]http://crm.sybase.com/sybase/www/ESD/ase_125_dev_download.jsp[/URL]

I do know that 'bcp' (and some other tools) come with the 'server' product, but I am not sure if they com with the client product also. (Actually I just checked and although it's not 100% clear I doubt they come with the client).

Documentation on using bcp (and all the other docs for Sybase) can be found here:

[URL unfurl="true"]http://sybooks.sybase.com/asg1250e.html[/URL]

For bcp, you will want to look at the Utility Guide, but I suggest looking at the T-SQL (transact SQL) manual too if you plan on starting to write stored procs etc.

Hope this helps.

-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects