Hello again,
I'm learning more and more as to how badly the data is set up where I work.
Currently, I have many excel files containing 256 columns of data (these are actually coming from .sav (SPSS) files containing 600 or so columns ). Here's the kicker: there are only about 25 rows.
What I'd like to do, is on import of these excel files, have access divide them up appropriately and create a relationship between the tables.
The primary key would always be the first column, and the number of columns per access table would vary (no more than 30).
I could do this manually, with the GUI wizard, but its very time consuming.
I Google'd for over an hour and didn't find the answer I'm looking for. I'm probably wording my search incorrectly.
Is this doable?
Edit: HA! Copied my thread title and Google delivers.
http://www.mrexcel.com/forum/showthread.php?t=375745