Link or Export Excel

[jh3016]

I need to develop a complex database and hope I'm not over my head. I would appreciate ANY help I can get. Thanks in advance.

For starters:
I have an Excel spreadsheet that I would like to link or export into Access. Some of the fields are:

CustName (I want this to be on the main form)
OrdValue (this will tie into the CustName and will be the subform)
OrdDate (this will tie into the CustName and will be on the subform)
In other words, it will be a one to many relationship. The Excel spreadsheet will list the CustName on each line.

I wanted the Access form to have the CustName on the main form and then in spreadsheet-like format list the different OrdValue and OrdDates.

This information is updated weekly so I would like the ability to either link or export this information.

In addition, I have some fields that are not on the Excel spreadsheet (fieldname = Comments). I want the comments to stay and just update everything except the Comments.

Please ask me any questions. Thanks.

 

[janetlyn]

jh3016, did you ever figure out how to do this? I need to have some Fields in a form, populate from some cells in a spreadsheet. Thanks, JL

 

[jh3016]

Unfortunately, I'm still looking for an answer.

Can anyone help?

Thanks.

 

[newmanje]

Have you tried creating two separate tables:
tblCustomer
tblOrders

You should then be able to link the two with an ID field then display the data you need.

James

 

[janetlyn]

jh3016, I am so sorry. I resolved this issue and am now importing excel table from a spreadsheet. I forgot to come back and tell you the solution. Go to thread 702-741641. That is where I got help. Sorry. Janet Lyn