Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Exporting fields from access to excel
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... |
#2
|
|||
|
|||
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. "Chris" wrote: 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Send Excel data to Access through button | Excel Discussion (Misc queries) | |||
Exporting from Excel to a Fixed Length Flat File | Excel Worksheet Functions | |||
Paste Access data into Excel spreadsheet | Excel Discussion (Misc queries) | |||
MS Access in Excel | Excel Worksheet Functions | |||
Importing data from Access into Excel: prob w/ cutting off fields | Excel Worksheet Functions |