I recently did an ex****t from FileMaker Pro v9 to an Excel spreadsheet.
The
result was one of the most poorly formed spreadsheets I've ever seen. In
essence, you've got one row containing information like customer id,
phone,
contact info, etc. Then another row where the aforementioned columns are
empty but there are other columns (like fax number) that contain data
relating to the same customer ID.
Now, thus far, I used a VBScript I found online to fill in all of the
empty
customer ID fields in Access so that at least all of the data/columns can
now be assigned to the correct customer ID (on the row above) upon im****t.
Now, my goal is to migrate from a relatively simple FileMaker database to
MS
Access. What I figured I'd do is just im****t the Excel spreadsheet.
However, I'm not seeing how I can merge the primary key which, in this
case,
would be the first column.
Based on the description/image above, is there a way to accomplish this
merge in Access or am I going about this in the completely wrong way.
Granted, I'm relatively new to Access but the type of table I'm wanting
to
create isn't that complex.
I just want all of the customer data (currently spanning two rows in
Excel)
to be assigned to the one customer id listed in the first column/field.
Hopefully that made sense. My apologies if it didn't but thanks to anyone
who can offer some guidance!
|
