How to prepare an Acess database to export data into Excel?

[Guest]

I must prepare an Access-based database for exporting the data into a new
Access-based database. First, they want to export the data into Excel.

How do I prepare the database for this?

Thank you!

 

[John Nurick]

I must prepare an Access-based database for exporting the data into a new
Access-based database. First, they want to export the data into Excel.

Normally it's neither necessary nor desirable to use Excel as an
intermediary for moving data from one Access database to another. If you
can't import the data directly to the new database (using File|Get External
Data), create a new, empty Access database and import the data into that;
then, later, move it to its final destinaation.

How do I prepare the database for this?

If you're not going to use Excel as an intermediary, no special preparation
is needed. If you are going to use Excel, you need work round Excel's
limitations (e.g. a limit of 65,536 rows in any worksheet) and the
complications that can arise when importing data from Excel into Access.

 

[Guest]

Thank you very much, John. I will ask the company that is designing the new
database, why they wish to have it exported into Excel first, and then take
it from there. I am dealing with two different developers, so who knows how
this will go.

I really appreciate your note. Thanks

Penny