How to export ENTIRE access tables to csv file

[Guest]

I have created a table by writing a function. The table has a least a million
rows, and about 9 columns. How can I export this table to a csv file?
Currently I am able only to export the portion that I am viewing (like the
first 10,000 rows).

 

[Guest]

Not sure about all your records...

What code do you use to make the csv??

TIA - Bob

 

[Guest]

I just select export as text file and manually add .csv to the file name

 

[Guest]

Thank you.

I will need VBA code to have this running properly.

Bob

 

[Guest]

What do you mean?

Thank you.

I will need VBA code to have this running properly.

Bob

 

[Guest]

Just a Button to run probably a DoCmd...

What do you mean?

 

[Charlie Hoffpauir]

I have created a table by writing a function. The table has a least a million
rows, and about 9 columns. How can I export this table to a csv file?
Currently I am able only to export the portion that I am viewing (like the
first 10,000 rows).

I've been reading your dialog with Bob, and since I couldn't
understand what Bob was saying, I decided to try to generate a CSV
file from one my databases, using the same technique you said you were
using. I chose a simple but large table.... 10 fields, 2,870,830
records. I checked the resulting txt file using EditPlus (which I use
for large text files) and it got all the records... no apparent
problems at all.

FWIW, I'm using Access 2000. Maybe you're not using the "Export"
function properly? Or how are you checking to see what you got in the
text file?

Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

 

[dbahooker]

if you were using Access Data Projects; this would be QUITE easy to do
using BCP.exe.

ADP rocks; MDB is for babies.

-Aaron
ADP Nationalist

 

[Guest]

Hello, where can I find or download EditPlus? I used this method and it
appears to have saved it fine but when I click to open it open in excell and
says it did not load the whole file and I only see 65000 enteries out of the
2,000,000.00 plus that are there.

 

[Guest]

Hello again, I found and downloaded EditPlus. When Opeing the csv file using
EditPlus I got an warning message

File is too large!
Physical memory:510mb
File size limit 127mb

you can have unexpected error,
Do you still want to continue

 

[Charlie Hoffpauir]

Hello again, I found and downloaded EditPlus. When Opeing the csv file using
EditPlus I got an warning message

File is too large!
Physical memory:510mb
File size limit 127mb

you can have unexpected error,
Do you still want to continue

I haven't seen that message... apparently my files are smaller, but I
also have a lot of memory available....

Anyway, you might want to download another editor. This one is free
(no time limit) It is PFE or Programmer's File Editor, available from
http://www.lancs.ac.uk/people/cpaap/pfe/
or
http://www.lancs.ac.uk/staff/steveb/cpaap/pfe/default.htm

I'm not a Excel expert, but I recall that Excell has a limit of
something like 65000 rows... so that could be the reason you're only
seeing 65,000 when you import into Excel.


Charlie Hoffpauir
http://freepages.genealogy.rootsweb.com/~charlieh/

 

[John Vinson]

Hello, where can I find or download EditPlus? I used this method and it
appears to have saved it fine but when I click to open it open in excell and
says it did not load the whole file and I only see 65000 enteries out of the
2,000,000.00 plus that are there.

I believe that Excel itself is limited to 65536 rows. This may be
version dependent - check the Help.

John W. Vinson[MVP]