how down load access file to excel

R

Ray Cacciatore

I had this problem about two years ago. If I remember correctly, you need to
save the table as a .CSV file (which can be opened by Excel). Keep in mind
that Excel has a limit of 35656 lines (or something near that amount). By
exporting it as a CSV file, you end up having all your rows into the file.

Ray
 
J

Jeff Boyce

Holly & Ray

Depends on which version of Excel.

I just opened my copy (Excel 2002), selected Help and used "specifications"
to find it could hold over 65,000 rows in a worksheet.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
H

Holly

My excel is XP, not sure which version is it. But in Help/specificatio, it
shows 65,536 rows max.

In this case, I still need help to find a way to export 50K rows from Access
to Excel. Also, I only need around 50K rows, they are less than 65K rows. Why
can't I export all the data from Access to Excel?
 
J

Jeff Boyce

Holly

Not sure your definition of "export".

Have you tried highlighting the table in the database window, then selecting
File | Export, and selecting Excel as the format to export to?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
H

Holly

I know what's wrong, I didn't highlight all the area.

Now, the column "Date" were not exported by sorted date in excel. The orders
show in excel are not same as "Access".

Is it a way to keep the same order of all access records in excel?

Thanks, Holly
 
J

Jeff Boyce

Holly

Access tables are "buckets o' data", and have no particular order.

If you want to sort the data in a table in a particular order before
exporting, create a query and do the sorting there. Then highlight the
query and export it.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top