Importing from excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sheba - 13 Sep 2005 15:10 GMT

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

Reply to this Message

Klatuu - 13 Sep 2005 17:45 GMT

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.

> 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
[quoted text clipped - 5 lines]
>
> C

Reply to this Message

Sheba - 13 Sep 2005 17:45 GMT

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

> 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
[quoted text clipped - 10 lines]
> >
> > C

Reply to this Message

Klatuu - 13 Sep 2005 17:46 GMT

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.

> Thanks...Is VBA part of the office package....it doesn't show up under tools
>
[quoted text clipped - 12 lines]
> > >
> > > C

Reply to this Message

Sheba - 13 Sep 2005 18:02 GMT

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

> 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
[quoted text clipped - 18 lines]
> > > >
> > > > C

Reply to this Message

Klatuu - 13 Sep 2005 18:15 GMT

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.

> I'm not familiar...Do they have a VBA book for dummies?...Any sugguestions on
> where to find info
[quoted text clipped - 21 lines]
> > > > >
> > > > > C

Reply to this Message

Sheba - 13 Sep 2005 18:29 GMT

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.
[quoted text clipped - 25 lines]
> > > > > >
> > > > > > C

Reply to this Message