Exporting To Delimited File

[Robert Raley]

Access 2003,

I have just recently upgraded from Access 2002. I would like to export to a
csv file using | as a separator. First On the export menu I can not find
the save as CSV file format and then I need how to use the | as a separator.

I would also like to know how to export into a format that MYSQL can import.

Thanks for your help.

Robert M. Raley

 

[Joe Fallon]

CSV is just one specific type of ACSII Delimited text file.
(Comma is the delimiter.)

I prefer the pipe delimiter myself as it makes the data easy to read and is
not usually part of the data itself.
=======================================
To fix your list of files of type:

Try re-registering the dll files like this:
Start Run
regsvr32 msexcl35.dll
regsvr32 msxbse35.dll
regsvr32 mspdox35.dll
regsvr32 mstext35.dll

Use 40 instead of 35 for A2K and 2002.

That's MSEXCL35.dll not MSEXC1.dll.

 

[Robert Raley]

Dear Joe, Thank you for your quick response. I did exactly as you
suggested and nothing. I then did exactly as you suggested, restarted my
machine and nothing. What I find rare is that in Excel 2003 I have the
option to save as CSV. Just as a side note I do not have the CSV option in
Save as on the export menu or in the Macro menu for output to.

This thing is driving me nuts as my web developer is on my back for his
template files.

What's next?

Many thanks

Robert M. Raley

 

[Robert Raley]

Joe I notice that this fellow has the same problem.

Bob Raley