G
Guest
How do I export query results greater than the 65,000 excel limit?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
To where?
Regards
Jeff Boyce
Microsoft Office/Access MVP
Regards
Jeff Boyce
Microsoft Office/Access MVP
G
Guest
Upgrade to 2007 Office Professional. The 2007 version of Excel handles a
million rows if I remember correctly.
million rows if I remember correctly.
G
Guest
to a text file
Jeff Boyce said:To where?
Regards
Jeff Boyce
Microsoft Office/Access MVP
J
Jeff Boyce
?Save as comma-separated or as txt file?
Regards
Jeff Boyce
Microsoft Office/Access MVP
Regards
Jeff Boyce
Microsoft Office/Access MVP
G
Guest
I'm not sure. What I need to do is to take the results of this query and
send it someone else so they can put it into their own access database as a
table. Someone said to export as txt file, but they weren't really sure
either. There are multiple columns.
send it someone else so they can put it into their own access database as a
table. Someone said to export as txt file, but they weren't really sure
either. There are multiple columns.
J
Jeff Boyce
Aha! If the other person also has Access, why not just save it as a table
in Access?
Regards
Jeff Boyce
Microsoft Office/Access MVP
in Access?
Regards
Jeff Boyce
Microsoft Office/Access MVP