Exporting from Access to Excel

[Guest]

When I try and export a table from access into excel, only 16384 are
exported into excel. Any idea how I can overcome the row limitation? Running
Access & Excel 2002.

I try http://support.microsoft.com/default.aspx?scid=kb;en-us;201589 and
specify Microsoft Excel 97-2000 format, but I stil have only 16384 rows.

André

 

[John Nurick]

Hi André,

Try using File|Export instead of Tools|Office Links|Analyze... The latter
seems to use old code that imposes the 16384-row limit even when you select
an Excel format that allows more.

 

[Ken Snell [MVP]]

File | Export also uses that old EXCEL format with the row limitation. Best
to use TransferSpreadsheet via macro or VBA code.

 

[John Nurick]

File | Export also uses that old EXCEL format with the row limitation. Best
to use TransferSpreadsheet via macro or VBA code.

Can you check this, Ken? I've just used File|Export on a query of 54,761
rows. All of them showed up in the worksheet. ISTR that selecting "Save
Formatted" while exporting to Excel involved the 16k row limit, but this
too exported all the rows just now. (Access 2003, exporting to Excel
97-2003 format)

 

[Ken Snell [MVP]]

Can only speak to A2K2; I know that "formatted" export uses that old EXCEL
format.

Maybe MS fixed this in A2K3!!?? That would be great if they did!

 

[Guest]

I had a similar problem trying to send the contents of a table using the send
object command. The way I got around the problem was to send the object in
Html format and then import the data in Html format. You can also open the
Html output in Excel.

Can only speak to A2K2; I know that "formatted" export uses that old EXCEL
format.

Maybe MS fixed this in A2K3!!?? That would be great if they did!