Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
See Answers Below:

choice said:
Im just learning Access, so please forgive my ignorance,
Click to expand...
None of us were born knowing Access
If I am using excel, how can i add a entry into a database from excel.
Click to expand...
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?
Click to expand...
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.
 
Back
Top