Importing data from Access to Accel

[Guest]

I am importing external data from Access to Accel. Instead of importing the
name of the vendor, it brings in only the ID# of the vendor. I suspect this
is because I use a lookup box to extablish the vendor's name in the database
file. At any rate, how can I overcome it and get the name to come across?

Rich

 

[Guest]

Hi Rich,

Would that be Excel instead of Accel?
I suspect that you are correct about the Lookup field. Lookups defined at
the table or query level are the creation of thy evil one. See the second
commandment of Access, here:

The Ten Commandments of Access
http://www.mvps.org/access/tencommandments.htm

You can create a query that includes your base table, along with any lookup
table(s) that are referenced by lookup fields. Hopefully, you will have
already created relationships between your tables
(http://support.microsoft.com/?id=304467). Add the fields that you want
displayed in the QBE (Query by Example) grid. Do you include fields where you
know in advance that a table lookup has been defined; instead, include the
looked-up field from the related table. Save the query. With Excel minimized,
you can now drag your saved query to the minimized Excel icon in the taskbar.
Excel should activate when you do this. While continuing to hold down the
left mouse button, position the mouse to the cell that you want to use. Then,
release the mouse button to paste the data.


Tom Wickerath
Microsoft Access MVP
(Bellevue, WA.)

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Correction:
The sentence that reads:

"Do you include fields where you know in advance that a table lookup has
been defined; instead..."

was intended to read:

"Do not include fields where you know in advance that a table lookup has
been defined; instead..."


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[strive4peace]

Hi Rich,

You should not use lookup fields in your tables, the place to use a
combo is one the form. In the table, you are actually storing a number
but it is showing you text... In your query to generate the data for
Excel, join to the table that holds the Vendor names for the VendorID
and put Vendor on your grid.

Don't use lookup fields in table design
http://www.mvps.org/access/lookupfields.htm

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*