Importing from excel

[Guest]

I have a DB in MS access 2000 with a one-to many relationship, two tables.
One Table has employee data, the other has donations. An employee can donate
many times. I created a spreadsheet for divisions to enter the data, 5
elements. When I import data into the donations table, the data doesn't link
with employee table. I'm using the ssno as the ID. If I enter data directly
into the donations table, the data is linked to the employee table. How do I
get the imported donations data to link to the employee table?

C

 

[Guest]

I assume you are using the TransferSpreadsheet method. If so, that is beyond
the capability of that method. I would suggest you link to the spreadsheet
as table, then create a query or VBA code that will load the data into the
tables.

 

[Guest]

Thanks...Is VBA part of the office package....it doesn't show up under tools

 

[Guest]

VBA is in every Office application. It is what is used to write Excel Macros
and it is used in Access, but not to be confused with Access Macros which are
different. In your case, you would need to do the coding in Access. If you
are not familiar with VBA in Access, you will need to get some information
and training on it.

 

[Guest]

I'm not familiar...Do they have a VBA book for dummies?...Any sugguestions on
where to find info

 

[Guest]

Yes, I think there is a VBA for Dummies book. You can also go to any
retailer that sells technical books and see if you can find something there.
If there is a Fry's near you, they have a good technical book section.

 

[Guest]

Thanks for all the help....Have a great day :-}

Yes, I think there is a VBA for Dummies book. You can also go to any
retailer that sells technical books and see if you can find something there.
If there is a Fry's near you, they have a good technical book section.