Import from Excel - by specific cells - help!

[BigMrC]

We are setting up automatic importing of data from excel sheets to access database. I want to code something in access that at the click of a button will find the correct spreadsheet (excel sheets will be numbered corresponding to the current Access record), will append data from specific cells in the excel sheet to specific columns in an access table.
How do you import from excel to access specifying by cell etc?
thanks

 

[kweitzel]

Hi BigMrC,

why don't you import the data in a complete table, then run a query where you select the required fields, store the data in a temp-table and the run an appen query?

This is sort of what i do in the previous post where i need help.

Hope it helps getting you started ...

Klaus

 

[BigMrC]

The excel sheets are from a customer - they don't just contain data, they contain the customer's logo, address, various details, specification numbers etc. We just want to extract the data relevant to us which would mean specifying specific cells.

 

[kweitzel]

Hmmm ... I read in an earlier post something similar ... but sorry, cant actually remember where, exept that it was in a forum here ...

It had to do with select row and column ... maybe try to search for tha.

Sorry of not beeing of better help ...

 

[DrSimon]

One way to do this would be to drive it all from Excel. Create a Macro/VB in Excel which copies the appropriate data to another spreadsheet and save it. Create a macro in Access that is capable of importing the new saved spreadsheet and then closing Access. Now add a call to Access (using Shell) from the Excel code using command line syntax to open the appropriate database and macro. This should work - all you need to do is add the details!
Simon Rouse