Importing spreadsheet with matching name fields

[Maracay]

Hi guys,

I need to import a excel sheet into a table in Access, because the names of
the files in the sheet may vary I think that is better to get the data using
the field names that will be always the same, the first row in the sheet
contain the name of the field and there are matching fields in the access
table with the same name, because this process will be executed several times
a day I want to create a form with a button to load the data into the table,
ideally I would like to have the option to browse the file but if this is not
possible a fix location will be Ok.

Some of the field names are: Name, Last name, Address1, Address2, City, and
Postal Code.

Any help will be appreciated.

Thanks

 

[Ken Snell \(MVP\)]

See this article:
Browse to a single EXCEL File and Import Data from that EXCEL File via
TransferSpreadsheet
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#ImpBrowseFile