Importing From Access

[Cobra17]

I have an excel spreadsheet that I want to be able to manually enter a 'Job Number' in 'C4' and then press a button. When the button is pressed it imports data from an access database called 'JobInfo', from a query called 'qryImportToExcel', but I want to filter my query field 'JobNumber' by excel 'C4' value. There will be only one row of data for each 'JobNumber'.

when importing the data, I need fields from the query to go to specific cells. example: qryImportToExcel!CustName should go to 'C5', qryImportToExcel!CustCity should go to 'C8'.

I tried using the power query but I can't get it to filter from a specific cell or add the values where i want them to go.

any help or good references would be apprciated.

[alansidman]

Look at this link an see if it helps to guide you in the right direction.


http://accessblog.net/2006/07/export...cel-range.html

[ranman256]

adjust to put the retrieved data where you want.

Please Login or Register  to view this content.

[Cobra17]

ranman256:

I put the code into a module and I get an unrecognized database format. I noticed you have a .mdb, I have a .accdb Is that the issue and can it be modified?


I do have Microsoft Office 16.0 Object Library set up as a reference and I tried

[Cobra17]

bump for some more guidance.

This sort of works, but I can't figure out how to filter. I've been trying to edit this line with no luck:

[alansidman]

Did you look at the link I provided?

[Cobra17]

I did check out the link.


I managed to get the code to work: