Importing from Access to Excel

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

Guest

I am importing data from Access into an Excel file. When I do this I can not
get my lookups to work in excel from this data. How do I get Excel to
recognize the data I pull in from Access? I have Vlookups that are not
working plus when it pulls in the date the week formula will not work. What
am I doing wrong? Thanks!
 
Why would you expect Excel to behave as Access does? If you have embedded
lookup data type fields in your Access tables, you have been storing one
thing (a key value) but displaying something else when you look in the table
(i.e., the "looked-up" value).

How are you exporting data from Access to Excel? Are you using a query to
get the data you want, then exporting that query? (i.e., the data returned
by the query).

VLookups are Excel functions ... Access doesn't have this, as far as I
remember.

If you describe what you want to accomplish, rather than how you are trying
to accomplish (whatever it is you are trying to accomplish), folks in the
'group might be able to offer alternatives...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have several excel files that have the same information in them. This same
information is in an access database. Instead of changing all my files when
something changes I am setting it up to link them all so it will update
itself. I need to export the data from the access database into my file that
is doing several lookups on tables I have in these files, so that I can
calculate information needed for my reports. So far I can get it to export
the data from Access to my excel file with a query, but once it is in there
my lookups don't recognize the data and give me #NA & #REF!. I need to find
out why it is doing this and how to get it to recognize the information I am
pulling in.
 
Hopefully one of the other newsgroup readers can offer you some leads on
this.

I'm not aware of a way to make Excel use Access' lookups (unless, perhaps,
you resorted to considerable programming and automating Access and Excel
objects).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
My lookups are in Excel. Everything is fine until I get my data into excel
and then that is where I run into the problems. Thanks for trying to help
though.
 
I've never done much with exporting data to Excel, but the #REF errors
make me wonder if somehow whatever method you're using is deleting cells
or rows of existing data before writing the new data.

That in turn made me wonder if Ken Snell's investigation of the Range
argument of TransferSpreadsheet might be pertinent. See
http://alexdyb.blogspot.com/2006_07_01_alexdyb_archive.html
under the heading "Export to Excel range".
 
Back
Top