CSV Export report not working

[access2010]

The previous instructions for creating a CSV file, from many years ago is shown below
===
Using Access 2003
Open the report (I also tried using the query)
File (Menu) --> Export
Save as Type 'Text Files'
Don't use the 'save formatted' option (I cannot see this function)
That will bring up the Export Text Wizard (I cannot see the choices below)
Choose Delimited, click next
Choose 'Comma' delimiter and " as Text qualifier.
Choose 'Include Field names on First Row' if you want column headings
Click next
Give it a name and click finish
That will give you a CSV file.

Your assistance is appreciated.
Nicole

 

[Minty]

So what is the problem exactly, It doesn't work isn't telling us much ?
Are you actually using Access 2003, or something else, your user name would indicate Access 2010.

The tool in later versions (this is 2016 but it's a similar menu layout from memory) is under Text export;

 

[Gasman]

The process is the same in 2007 ?

 

[access2010]

Thank you for your note.
Yes, we are using Ms Access 2003 and the name (Access 2010) is our user name that one of the Volunteers at our NGO setup.

Please look at the uploaded document, for screen shots of what we have done.

The extension of the file is .CSV, but the data in the file is text.

Can you please let us know how we can correct our problem in creating a CSV file?

Thank you,
Lisa

 

[Gasman]

Change the .txt extension to .csv
Show the contents of your .txt file

 

[access2010]

Thank you for your suggestion, Change the .txt extension to .csv.

This does not work.

Nicole

 

[GinaWhipp]

Hmm, .CSV is used by Excel. Try exporting as an Excel file and see if you are given the option to save in that format.

 

[isladogs]

Thank you for your suggestion, Change the .txt extension to .csv.

This does not work.

Nicole

What exactly does 'this does not work' mean?

Why do you want to create a csv file from a report?
If you want to keep the formatting, export to PDF.
if you want to export the data only, instead export the underlying table o query as a CSV file

 

[Gasman]

Colin,

Access 2003 did not have PDF export I seem to recall, nor save as PDF.
When I was using it, I printed to a pdf driver. 2007 was a godsend.

 

[isladogs]

Hi Gasman
The clue is in the user name - they are using Access 2010 now.
Code in post #1 was old code used with Access 2003

 

[Minty]

@Colin - Actually in post #4 they state they are using 2003. I asked for that clarification early doors...

 

[isladogs]

Sorry. My bad

 

[Minty]

Sorry. My bad

Confused me as well

I'm out of here for a few days of getting wet whilst playing golf. Actually we're probably playing cards looking at the delightful weather we have in store!

 

[isladogs]

Minty
I thought you played Polo

 

[access2010]

Thank you all for trying to assist us.

What we have done which works is shown below.
The MsAccess 2003 report was exported as an XLS file
The XLS file was renamed to CSV

Thank you
Lisa

 

[GinaWhipp]

Glad you got it fixed! That said, you might want to consider upgrading as the older Access gets more and more *issues* will most likely arise.

 

[Gasman]

What application was using the csv file?, as the internal structure is completely different, and you can't just rename file extensions as you see fit in that case.?

Thank you all for trying to assist us.

What we have done which works is shown below.
The MsAccess 2003 report was exported as an XLS file
The XLS file was renamed to CSV

Thank you
Lisa

 

[access2010]

Thank you for your note.
We use a program that uses the CVS file to take Equity Data from Yahoo.
Nicole

 

[Pat Hartman]

The MsAccess 2003 report was exported as an XLS file
The XLS file was renamed to CSV

That's like changing the slip cover on a book from English to French and expecting the contents to be converted.

DO NOT EVER SIMPLY RENAME A FILE EXTENSION. All that will do is cause confusion. Windows uses the file extension to determine what application should be used to open the document. Most modern applications are agnostic these days regarding what file extension you use but they STILL CARE about the actual format. For example, I can rename myAccessApp.accdb to myAccessApp.xyz. If I double click on the name, Windows will complain because it doesn't know what application to invoke. However, if I open Access and then navigate to the file and pick it from the list, Access won't care.

A2003 can write data to .csv (which is a text format that you normally would open using notepad) or .xls (which is an Excel format that looks like gibberish if you open it with notepad)

 

[access2010]

Our NGO, has Office 2007 CDs from which we had only been using 2007 Word.
We installed the Ms Access program, but when doing an export test, we can not find a CSV exportable portion.
Please advise, where this CVS extension is in Ms Access Office 2007?

Thank you,
Nicole