Problems creating a .db in access to link to a excel spreedsheet

[mike]

Hi,
Ok, here is the problem that I am having which I hope someone can help me
out with. I am using ms xcel 97 and ms access 97. What I would like is a .db
file where I just can enter the date time and a value and that it will go
automatically to my spreadsheet and if I change a value it will
automatically update the spreadsheet. Sounds easy but I am have no luck.
Here is a example:
Date time day evening night
6/1/04 0:00 300
The above is what I would just like to enter and then I want it to look the
same in the spreadsheet.
Here is what I tried.
1) Went to access and created a blank .db
2) Then I created a new table using the data sheet view. In field one I type
in date, field 2 time, field 3 day field 4 evening, field 5 night. Next row
I typed in field one 6/1/04, field 2 0:00, field 3 0, field 4 0, field 5
300.
3) I then saved it as a table1.
4) I tried both to create a primary key and it did not make a difference.
5) I then highlighted the new table and went to new and then link table.
6) I then picked my my spreadsheet file .xls which I already created.
7) Next I exited out and saved everything.
I next tried to add some more data and it just did not update my
spreadsheet.
If someone can tell me what I am doing wrong it sure would be appreciated.

 

[Larry Daugherty]

Answered in another newsgroup.

Don't multipost (copying the same post into several newsgroups). Crosspost
instead: put each newsgroup in the header of your post and an answer in one
newsgroup percolates to all of them. Thus saving having several people
answering what they thing is your unanswered issue. If they see an answered
post and believe they have something relevant to add, they will.

Again, check out www.mvps.org/access be sure to look up netiquette.

HTH