Export foxpro db to text file...

[symo...@my-dejanews.com]

Hey all,

I'm asking this on behalf of the db guy, so please excuse the lack of detail
:)

We want to export a foxpro db (.dbf) file to an ASCII text file, so each field
is surrounded by quotes. This is so that we can import the data easily into
another application.

If anyone has an idea of how to do this, plz forward a copy of your reply to
sa...@transport.wa.gov.au , as my email feed is not the best :(

Thanks for your time,

- Symon...

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

[Anders Altberg]

USE <table>
COPY TO textfile [TYPE] DELIMITED [WITH cChar1 [WITH CHARACTER cChar2]
cChar1 is " " be default and cChar2 is , a comma.
COPY TO textfile TYPE DELI will get you lines like
"Bill",1234,"Sidney"
COPY TO textfile DELIMITED WITH "'" WITH CHARACTER ";" FOR name = 'B' would
get you
'Bill';1234;'Sidney'
If you <want a top line with fieldname use TYPE CSV instead of TYPE DELI

-Anders

<symo...@my-dejanews.com> wrote in message
news:7ehl2j$mne$1...@nnrp1.dejanews.com...