Newbie Needing Help

[KantFigureItOut via AccessMonster.com]

Hello all, and thanks in advance. I have done a search to see if this has
already been discussed and I am sure it has but could not find anything on it.
I am a newbie to Access so I do not have all the correct terminology down pat.
So with that said, let’s give this a shot. I want to pull data from a excel
spreadsheet, (TblBTRWork) which is linked, into a form which will have the
fields on the excel spreadsheet along with other fields that I need. I would
like the form then to record this data into another table (TblMain) with the
updated information. At a later point I will need to go back and update
(TblMain) with information through a “form view†preferably. Any help would
be greatly appreciated. I hope this does not seem like I want someone to
build my database, I have just got to a “stuck†point and I don’t know how to
look it up when I don’t know what I need to even do. This is a great site and
hope I am not asking too much. Thanks

 

[KantFigureItOut via AccessMonster.com]

By the way, I am running Access 2003

 

[Golfinray]

Pulling from the linked table is no problem. You will need to do a query
because you "want to pull data from this table and another?" To put tables
together, you need a query to connect that information for you. To record
that data into another table you would need a make-table query which you
would build from your query or you would have to use an update query for an
existing table. You can build a form from your query that will automatically
update your query. I feel for you, hang in there. It won't be easy but you
can do it.