Exporting data

  • Thread starter Thread starter luis.a.roman
  • Start date Start date
L

luis.a.roman

Is it possible to create a macro in access to get an excel file and
loaded automatically to specific table?

I understand the I can use the export/import access wizard but would
like to automate the process.

Suggestions, examples or web links that I can search for this will be
appreciated.

Business problem: Macro to upload excel spreadsheet automatically to an
existing table.

Luis
 
If you are using Marcos, then I would suggest using the
TransferSpreadsheet option.

If the file is on a server be sure to map the entire drive path,
exclude Drive Letters as it will cause issues down the road.

Once you choose TransferSpreadsheet you will need to at a minimum fill
in the following options.

Transfer Type = in your case this would be Import
Spreadsheet Type = the version of excel file
Table Name = Name of the table in the current database
File Name = \\server location\file name.xls
Has Field Names = is the first row of the spreadsheet containing the
same names as in the table Yes or No?
 
Back
Top