Exporting a access file that is greater than 65,000 records

[Lior123]

Hi,

I have a query I ran that has about 850,000 records.

How can I export this to send it to someone?

Can I create a .csv file in Access 2007?

Please let me know.

Thanks

 

[Shortmeister1]

You can do it fairly easily via the EXPORT command. I don't have a copy of Access 2007 to hand so I can't tell you precisely, but on Access 2003, EXPORT is on the file menu. Select the export location and the file type (text) and click on Export All. You will then be presented with a wizard which will ask you a few questions including as what delimeter (eg Tab, Comma etc) you wish to use.

HTH
Martin

 

[james_lankford]

read Sydney's post in this thread

http://www.mrexcel.com/forum/showthread.php?t=374803&highlight=CopyFromRecordset

 

[SydneyGeek]

Hi,

I have a query I ran that has about 850,000 records.

How can I export this to send it to someone?

Can I create a .csv file in Access 2007?

Please let me know.

Thanks

You can create a CSV from Access. The TransferText method using the acExportDelimited option will give you a comma delimited file.
Problem is opening it on the other end; Excel will spit the dummy over the number of rows. If they are opening in a database, no problem. If they want to use Excel, use the link James provided to break the query over multiple tabs.

Denis

 

[boblarson]

Of course if you are using Excel 2007 then it will handle a million rows on a worksheet, right?

 

[SydneyGeek]

If you use one of the new formats, and not .xls...
Also assumes that the recipient has 2007.
Good point though -- should have noticed that.

Denis