Dbase5 Export Utility

[Sunwriter]

I have a 300+ field dbase5 table that I need to import to MSSQL 7.0. My DTS import is failing I believe due to a 255 field limit with my Dbase driver. (Access 2000 also has this limitation).

Can someone tell me where I might find a dbase5 utility to export the table to a comma-delimited file, for example. Once I have the data is this format I can work with it from there.

Thanks in advance for any assistance.

Jeff

 

[1oldfoxman]

If you have access to the dBase environment, the following should work. I have to say I've not tried that number of fields, but this is where I'd start.

USE MyTable
COPY TO NewFile.txt DELIMITED

You should get a file named NewFile.txt, comma delimited, character data inside double-quotes, CR/LF at the end of each record.

HTH,
dennis