Excel

C

choice

Im just learning Access, so please forgive my ignorance,

If I am using excel, how can i add a entry into a database from excel.
also
is it possible to do a vlookup in excel, with a database in access?

Thanks in advance
 
K

Klatuu

See Answers Below:

choice said:
Im just learning Access, so please forgive my ignorance,
None of us were born knowing Access
If I am using excel, how can i add a entry into a database from excel.
This is pretty advanced. It can be done, but it is more involved than can
be explained here. You might be better off to to either import or link you
Excel sheet as as Access table and get the data into Access that way.
also
is it possible to do a vlookup in excel, with a database in access?
Not sure what you are asking. There is no such thing as a VLookup in
Access. It is an Excel Worksheet function. The equivilant in Access would
be a Select Query with criteria set up to filter the rows you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top