Exporting fields from access to excel

C

Chris

Hi,

i know that it is possible to export data from Excal to Access and make sure
the data falls into specific fields, but can it be done the other way round?

I.e. can i have a preset spreadsheet with my fields designed, I click a
button (either or excel or access) then those fields becoem populated with
access info and there is no need for editing etc...
 
D

Duke Carey

Without programming in VBA, you have (at least) two manual options.

First way:
Create your Excel sheet so it looks like an Access table, with column
headers that match the field names in Access. Save it and close it.

In Access, go to the Tables tab, right click and choose Link Tables..
Select Excel as the file type, navigate to the file's location, and select
it. Step through the wizard to identify the sheet and column headers &
finish the wizard.

Now create an Append query & ID the linked Excel file as the target.

Second way:

In Excel use the Data menu, Get External Data | New Database Query. Find
the Access database & build the query.
 
Top