CSV Export report not working (1 Viewer)

access2010 · Oct 10, 2018

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 · Oct 10, 2018

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 · Oct 10, 2018

The process is the same in 2007 ?

access2010 · Oct 10, 2018

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 · Oct 10, 2018

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

access2010 · Oct 11, 2018

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

This does not work.

Nicole

GinaWhipp · Oct 11, 2018

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 · Oct 11, 2018

access2010 said:
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 · Oct 11, 2018

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 · Oct 11, 2018

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 · Oct 11, 2018

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

isladogs · Oct 11, 2018

Sorry. My bad

Minty · Oct 11, 2018

isladogs said:
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 · Oct 11, 2018

Minty
I thought you played Polo

access2010 · Oct 11, 2018

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 · Oct 11, 2018

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 · Oct 11, 2018

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.?

access2010 said:
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 · Oct 12, 2018

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

Pat Hartman · Oct 21, 2018

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 · Oct 24, 2018

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

CSV Export report not working (1 Viewer)

Registered User.

Attachments

AWF VIP

Attachments

Enthusiastic Amateur

Registered User.

Enthusiastic Amateur

Registered User.

AWF VIP

MVP / VIP

Enthusiastic Amateur

MVP / VIP

AWF VIP

MVP / VIP

AWF VIP

MVP / VIP

Registered User.

AWF VIP

Enthusiastic Amateur

Registered User.

Super Moderator

Registered User.

Similar threads

Users who are viewing this thread