Open filedialog, then import xlsx columns A-H in cleared table

[Whykonen]

Hello,

I have a xlsx file with useful information for contributions in columns A-H.

I am making an access database to import this data and print transaction forms. I figured out most of it, and i use a saved import to import the xlsx in a clear table(new table with the same name).

However, the filename is changing and i want a filedialog to open on clicking the import button. Then i only want to import columns A to H, the rest of it is useless or my part of the member information.

How can i do this? I tried vba code from the MSDN library: ( the dialog part ), and found the other part on this forum.

http://msdn.microsoft.com/en-us/library/bb243865.aspx
http://www.access-programmers.co.uk/forums/showthread.php?t=163138&highlight=import+excel

But i didn't get this working.

Thanks in advance!

 

[Dennisk]

What you can try is creating an import specification.

Select Import from the menu, and after completing the specification, save it. This can then be used in the import command.

The specification will allow you specify the types of date, seperator, fields etc.