Computing.Net > Forums > Windows 95/98 > CSV's in Access

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

CSV's in Access

Reply to Message Icon

Name: PeterK
Date: December 18, 2000 at 07:52:34 Pacific
Comment:

Does anyone know how I can dump an Access Query into a CSV file? I can get it to use a report and dump that into a txt file then do a dos rename (or tell access to rename it) but this has gaps inbetween the lines, I have seen that there is an output way of getting a query to use a text file but it formats this and so it is no good, as it is needed to be imported into a dos database.



Sponsored Link
Ads by Google

Response Number 1
Name: .
Date: December 18, 2000 at 21:32:45 Pacific
Reply:

Can you export to excel and save as .csv?


0

Response Number 2
Name: PeterK
Date: December 19, 2000 at 01:17:03 Pacific
Reply:

Thanks for replying
I could do this but excel messes around with the formating of fields, and if possible I would like this to be "Idiot Proof" and so requiring no user intervention.


0

Response Number 3
Name: Bryan
Date: December 23, 2000 at 19:08:12 Pacific
Reply:

DBF2CSV - a utility to convert .DBF database files to .CSV (comma-separated text) format. Includes Perl source code and two tiny Perl interpreters (one for DOS, one for Windows). http://www.nonags.com/files/?/cl/DBF2CSV.ZIP
Check your email. Happy New Year


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows 95/98 Forum Home


Sponsored links

Ads by Google


Results for: CSV's in Access

Reading CDRW's in standard CD-Rom d www.computing.net/answers/windows-95/reading-cdrws-in-standard-cdrom-d/142280.html

multicriteria search in access www.computing.net/answers/windows-95/multicriteria-search-in-access/126312.html

Frequent GPF's in Eudora 5.2 www.computing.net/answers/windows-95/frequent-gpfs-in-eudora-52/133449.html