Re: Text File Output

Hi Kevin

Yes exactly there is a carriage return between each record but in my
database all the information for one job is stored in one record so it
will be displayed as follows:

"123";"1";"C01";"123";"2";"C02";"123";"2";"D17" - then on to the next
record
"234";"1";"C02";"234";"2";"C35";"234";"2";"C56"

However in the external database they store details of one job in four
parts as follows:
JobDetail1
JobDetail2
JobDetail3 &
JobDetail4

So for example in their database table 'JobDetail1' would have records
as follows:

JobDetail1.txt
"123";"1";"C01"
"123";"1";"C02"
"123";"2";"D17"
"234";"1";"C02"
"234";"2";"C35"
"234";"2;"C56"

Therefore I need to know if it is not possible to export my data in
the format as above i.e. all on one line then is there a simple way
around it.

The file format is Comma Seperated Value text file (if that's what you
mean) but I have been asked to replace commas with semicolons once it
is in the text file.

Many Thanks
JayBee
.

Relevant Pages

  • Re: Btrieve legacy migration
    ... The first question is to figur eout your file format and database ... and get the white paper on "Finding Your Database Engine Version". ... do a STAT of one of your data files to determine ... or a description of the file format. ...
    (comp.databases.btrieve)
  • Re: Two questions about moving data between a SQL DB and XML
    ... better method of exporting data to a file format for later reimport be? ... Is there a better option than XML? ... dozen tables from one database and importing them into another database ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Stuff
    ... You don't have to have Access installed to use it's file format. ... Set ogAccess = Nothing ... End Function ' OpenDataBase ... of separate machines such that each person is accessing the same database ...
    (microsoft.public.vb.general.discussion)
  • Re: Working with fixed format text dbs
    ... file format for a commercial database application. ... And also, as you say, if the spec ever does change, the ... You could presumably define a list (of some sort, ...
    (comp.lang.python)
  • Re: Corrupt Access File
    ... and do you have the specifications for the Jet ... database file format so that you can check each bit for what it's supposed ... If database corruption is common enough in your environment, ...
    (microsoft.public.access.formscoding)