batch file

B

bob

Hello,


I want to make a txt file for importing data into another program(VERO).
This program needs a certain input, blanks here and tabs there and ....
Can anyone tell me how to prepare an access query (table) exactly with the
requestated format.
We are using Access 2000 on windows 2000 server platform.
Best regards,
Bob
 
A

Albert D. Kallal

Normally, you can do a LOT in terms of building a query.

You then export that query, and use the export wizard.

Often, you need to do things like take FirstName and LastName fields...and
export them as one field. So, you can build a expression in the query
builder that is the first and last name..and that solves this kind of
problem.

However, if the export file is not comma delimited, or "fixed" width, or TAB
delimited, and the formats is too complex for the wizard and what is called
export spec, then the you have to resort to writing code to make the export.

Have you tried the export wizard? Is the resulting data file just fixed
width, or tab delimited? ms-access can create these kinds of files without
you having to write code. So, you don't mention how much you have tried the
export system, and using "spec" for the export.

As mentioned, if desired results are simple fields separated by some
delimiters with *some* formatting, then use the wizard. If not, then you can
resort to writing your own code, and thus make any format you want. (check
out Open, print#, and write# commands in the help)
 
Top