transferring a database to Excel

[Guest]

How do I transfer an Access database (Access 2000 file format in Access 2003)
on my computer to Excel on another computer?

 

[Ken Snell \(MVP\)]

The whole database? or just some data from a table or query?

You can export data from a table or query using TransferSpreadsheet action
in a macro or VBA code (this is recommended over the File | Export process
in the menus because the Export menu will not export more than 16384 records
and will not export data that exceed 255 characters in a single field).

 

[John Vinson]

How do I transfer an Access database (Access 2000 file format in Access 2003)
on my computer to Excel on another computer?

YOu can't transfer and entier *database* - a container for multiple
Tables, Forms, Reports, Modules and so on - to Excel; they are
different programs.

You can transfer the *data* in Tables or Queries into Excel
spreadsheets. Select a table or query, and use File... Export. Choose
Excel from the list of options. This will create a spreadsheet (or you
can choose an existing spreadsheet) which can then be transferred,
either over a network, on a diskette or CD, or by EMail.

John W. Vinson[MVP]

 

[Guest]

You can also reverse the operation by retrieving the data from Access by
making a query in Excel via the Data--Get External Data menu option.

Dave