Importing from Excel

[fmaca]

Good evening all.

I hope this can be done easily.

I have to create an Access table from an Excel file. The excel file has multiple worksheets.

Each worksheet is set up to print nicely so instead of a single 400 line column it will have 5 60 line columns. I have been cutting and pasting each of these columns to make one long one.

Can this be done somehow in the import?

Thanks in advance.

Ethan