Bringing A 300+ Column Excel File Into Access

Someone asked an interesting question about Excel and Access, so
I decided to transcribe it here.

“I have an excel file with 300+ columns. I would to split and export
them to access as two table and join them. Could you please help me
with this.”

Thanks in advance,
Ma….

Here was my response:

“Hi Madhavi,

You can make 2 tables, and make some type of link identifier between them.

Then use that field to join the two tables in Access.

For example:

In column A, of your excel file enter some id, like 1 and autofill to the last record.
Then count your Excel columns to 250 paste it into 1 Access table, then paste the numbers in column
“A” into column 251 and put those into Access.

Use that number from column “A” as a linking field in Access to link the 2 tables.

Make sense?

Regards,

Erik Loebl”


Comments are closed.