Output to a text file

[Kflows00]

Hi all! I'm not sure if this is the correct area to post this in, but hopefully it is!

I have a Microsoft Access database, and I need to output the content of one of the tables in a specific format-the table contains a Name field, a Description field, a URL field and an Alt Text field, and I need it to end up in a text file in this format:

NAME|DESCRIPTION|URL|ALT|

Where each line of the text field is a different product, and the content of each field is separated by the | symbol (whose name escapes me right now).

Anyone that can help?

Kevin

 

[maxmangion]

from the database window, right click on your table and choose export, then select csv from the same as type.

Alternatively you can do it via VBA.

 

[zestygirl]

A fast & dirty way to do this, AND get the "|" symbols you're after:

Create a make table query. (assuming you already know how).
create a new output field using the expression:

New field=[Name]&"|"&[Description]&"|"&&"|" etc. Zap. Now, simply open y...atted records into word or excel or whatever.