mapping cell to column from Access-Excel

[AccessNewby]

Greetings- Thank you for viewing my question. I hope you can assist

I have an Excel spreadsheet that certain cells contain data that I would like to import to Access database. I know how to import/link features but I don't know how do I get it to go to a specific column. How can I map that in my codes?

TIA,
AccessNewby

 

[Ron_dK]

Newby,
Assuming you use the import spreadsheet wizard , one of the steps in setting this up is the Field options area.
In this part, there is a checkbox " Do not import field ( skip)".
You might use this one to select the columns that you want to import and those you don't.

Hth

 

[mattkorguk]

Hi Newby,
I may have this wrong but I read you question in a way that you'd like a column from your Excel list to be populated into a field on your Db, such as a combo box, is this correct?
If so, it's a simple query based on the Linked Excel sheet which the Combo box points to.
Or Rak could be right with their suggestion, a bit more details would be helpful.
Thanks
Matt

 

[AccessNewby]

Sorry for the late reply, I was under the weather. Thank you RAK and Matt for your suggestions. I'll give it a run.

Attached are an Access and Excel files. I am trying to find the most efficient way of transferring cells C2, C3, C4, C5 and c13, C14, c15, c16 from Excel to Access FedReceipt table.

I saw an Excel file that when you click on the macro icon "send to Access" and the specified data were transmitted to Access table just like magic. That is what I want to learn with your help. I'm not sure if this is a difficult task or not. Is this a VBA, Macro, Import/link issues ?

Thank you all again.

AccessNewby