Combine 2 row in Microsoft Access table

Question

I just have a question about importing a table to Access from Excel spreadsheet.

I am basically importing a table from Excel to Access enter image description here

And I want the final table to look like this in Access -

enter image description here

Is this possible in access? or does this need to be modified in Excel before import? If so can I write all of the modification code in Access VBA?

Thank you in advance!

There might be a way to alter the title in Access but it will be much easier if the modification is done in Excel (with code) prior to the import? — Alex
@Flyhigh you can do this pretty simply in Excel VBA or even a simple concatenate formula as well. Why do you have the requirement of doing this in Access VBA? — Chrismas007
I assume you need this in Access because you are going to do something else with this data once you get it in Access. If not, just do your manipulations in Excel. Following that, does the table structure already exist in Access or are you bringing this in as a new table? — KevenDenen
it was more for convenience factor. i just didnt want to open up 2 programs to just upload data on the database. I want to do it all in Access. Also this is for educational purpose as well. haha — Flyhigh

CarloC CarloC · Accepted Answer · 2015-01-21T18:54:53

Create a reference to Excel in Access.

In your Access VBA IDE Goto Tools>References and find/add Microsoft Excel ##.# Object Library reference.

You can then declare any variables (with intelliscense!) to Excel objects etc. and do all the required set up through Excel but inside an Access session.

Combine 2 row in Microsoft Access table

1 Answers