Primary Keys

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I recently did an export 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 import.

Now, my goal is to migrate from a relatively simple FileMaker database to MS
Access. What I figured I'd do is just import 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!
 
It seems to me, if I understand your description correctly, that you
need to merge the 2 rows that exist for each customer. Obviously, a
direct import of data into Access, in which 2 rows have the same
"primary key" will not work. You may find it easiest to copy and paste
the second rows to the first rows, delete the second rows, and then do
the import.

Let me know if I haven't understood your situation correctly.

Lynn Trapp
 
Back
Top