Is there a maximum number of data tables you can import..

[glenn.dphoto.com]

Hi,

Is there a maximum number of data tables that I can import from MS Access into a single MS Excel file.

I have successfully imported four (4) tables into four (4) different worksheets, but when I follow the same methodology to import the fifth and sixth tables, only the row headings are imported [in bold].

Can anyone help?

Thanks, glenn

 

[arthurbr]

Welcome to the board,
did you try importing your 5th and 6th tables in another workbook?

 

[Aladin Akyurek]

Re: Is there a maximum number of data tables you can import.

Hi,

Is there a maximum number of data tables that I can import from MS Access into a single MS Excel file.

I have successfully imported four (4) tables into four (4) different worksheets, but when I follow the same methodology to import the fifth and sixth tables, only the row headings are imported [in bold].

Can anyone help?

Thanks, glenn

Procedures to follow...

1) BitByBit.mdb --> BitByBit.xls with File|Export from within BitByBit.mdb. All of the 7 tables are exported.

2) BitByBit.mdb --> BitByBit.xls with Data|Import External Data|Import Data. All of the 7 tables are imported, each time choosing for New Worksheet.