TransferSpreadsheet Function

[Carl1]

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

 

[Norie]

Carl

There is the Name statement, which can be used in VBA.

Check the help file for the exact syntax.

Name "MyFile.xls" As "MyNewFile.old"

'populating' basically means adding items to the listbox, which you are doing with the AddItem method here.

Me.FileList.AddItem varFile

 

[Carl1]

Norie

Cheers

As it is Ive gone for the more drastic option and deleted the file once imported, using the Kill function.

Cheers for all your help.

Carl

 

[mdmilner]

Why not use FILECOPY?

Alternatively - you could always generate a log of successful imports and check during all imports so you don't duplicate anything. (compare names)

Mike