Excel Template to Import into Access

[alastair69]

Hello All,

I thought i would ask this question an how to import data from excel into access.

I am using sage to invoice clients and i can output this in to excel format then i would like the best and simplest way to pull the data though into access.

The data file has column headings at the first row ie A1 though to J1 and after this is the data, i have a table setup with the relivent table names, I had thought how easy this would be, but as always this was not the case.

The outputed excel sheet will vary in location so i think i need a diolog box to select the file and then some how link it to extract the data, is this right and if so how can it be achived.

Any thoughts

Alastair

UPDATE
**************************************Resolved Thanks to Pat Hartman *************************

 

[Pat Hartman]

I moved your thread to a more appropriate place.

Lookup TransferSpreadsheet Method/Action. It will allow you to import spreadsheets. If you need to choose a source at runtime, you'll need to use the TransferSpreadsheet Method rather than Action.

If you want to open the common file dialog, search for posts on the file dialog API. You'll find code samples. It is better to use the API code (which you just copy and place in a module) than the ActiveX control because you won't have any problems distributing the application as you might if it included activeX controls.

 

[alastair69]

Thanks For your Help on this one, i have sorted it all out.

Alastair