Help. I am not a particularly sophisticated Access person but have a basic understanding of Macros and have a slight problem with a Macro within Access.
I am trying to Import data (Will always be in same field layout - but in Excel) into an existing table (With Same Field Format - But in Access) and append this data to the table.
I have had some success using the TransferSpreadsheet function doing this but as I use Macros I have to set-up at the start the filename for the Excel File.
Is there a way that I can change this filename, so it looks at a different file each time (Will always be the same format)?
Ideally I would like to be able to just run the macro - and browse/search and dble click the actual file I want appending at that time.
Hope someone can help
Carl
I am trying to Import data (Will always be in same field layout - but in Excel) into an existing table (With Same Field Format - But in Access) and append this data to the table.
I have had some success using the TransferSpreadsheet function doing this but as I use Macros I have to set-up at the start the filename for the Excel File.
Is there a way that I can change this filename, so it looks at a different file each time (Will always be the same format)?
Ideally I would like to be able to just run the macro - and browse/search and dble click the actual file I want appending at that time.
Hope someone can help
Carl