Import from crazy Excel file

[indyaries]

Sorry for cross-posting. I posted this in the Tables forum, but have had no replies in over 12 hours.

I searched on IMPORT (72 threads), but didn't see anything like the problem I have.

I have a large Excel file formatted thus;
COLUMN A
1 Full Name
2 Full address
3 City State Zip

Columns B and on have other information for the employee in Column A.

I need to get the employee information in Col A into a tabular form, such as (A) Employee Name, (B) Address, (C) City, (D) State, (E) ZIP

If this could be done with the data in Column A, I believe I could join the employee info currently in Col A to the remainder of the data.

I've also looked at the Excel forum with no luck.

Suggestions would be appreciated !!

 

[Vassago]

There is no need to repost a question in another forum just because no one answers it. If people can answer it, they will, just be patient and hopefully someone will be able to help you. Double posting leads to redundancy.

Please don't do it again.

http://access-programmers.co.uk/forums/showthread.php?t=105823