Getting data into my database

[Guest_imported]

I've been given the task of converting a pretty darn huge Excel spreadsheet into an Access database. Now I've designed my table structures and made the relationships between them, my question really is. How the heck do I get the existing information into the the tables while sticking to referential integrity rules. Eg. I have to tables like so

Apps
---------
appID (PK)
vendorID (FK)
clientswID
adsgID (FK)
typeID (FK)
appname
appdescription

Vendors
----------
vendorID (PK)
vendorname

For the moment only pay attention to the appID and the vendorID the others aren't relevant at the mo. Any way i've made a one-many relationship between these two tables. In the spreadsheet two columns exist Vendor and Application, I've successfully managed to extract all the known vendors and managed to append them to the Vendors table, however since I'm wanting the vendorID in the Apps table to match up with that in the vendors table theres a slight problem appending the applications list to the apps table, while still trying to maintain the referential integrity which I have enforced (I've also checked the box for the update and delete cascade things). And I really don't fancy manually setting the vendors for over 600 applications. Can someone please give me a solution as I am a relative newbie to this Access lark???

 

[gerard1979]

don't understand ur problem at all but maybe the following helps
first make a csv formatted file from the Excelfile
import the file into the database
follow the wizard, check the necc columns and set the fieldnames the same as in the table
If ur appID is autonumber, doesn't care about it, it goes automatically, ur vendor ID must be the same type (numeric) as in Excel.
If it's not what u mean, give more info about the columns in ur excel file, so I can help further,
greetz,gerard

 

[Berny69]

Importing foreign values into Access tables with primary and secondary keys assigned is hardly possible. How about importing the raw values into the tables without any keys assigned and mark the keyfields after the import.