Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Missing fields when I import from Access to Excel...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AAOO (Sean) - 31 Oct 2006 21:50 GMT
Hi!, I have an auto update import on a access table, it works mostly
ok, it update all user entered fields ok, but the fields that come up
automatically when you make a selection somewhere else on the form
don't.  For example, when I select member # from a drop down, the First
and Last Names come up in the respective fields automatically.  The
drop down list, has the member # in one row, and the first and last
names in following rows respectively.  When I import to excel, it gets
the member #, but not the first and last names.  It doesn't even create
a column heading for them.  Other fields that are automatically filled
in also don't get imported, but I think I can use the solution I find
here for them as well.

Thank You,

Peace and Love,
 AAOO (Sean)
AAOO (Sean) - 01 Nov 2006 22:54 GMT
Nevermind, this turned out to be a problem on the access side...sorry...
CyberTaz - 04 Nov 2006 23:38 GMT
I think you'd be better off posting this to one of the Access groups. It
sounds like the record source you're using in the Access file is looking up
certain fields of data from other tables/queries for display purposes in the
object (Form?) you're trying to import from. It may simply be a matter of
importing directly from the Form's record source rather than the Form
itself, but I can't be sure without more info about what you're starting
with in Access... And quite honestly there are more qualified sources than I
in the Access groups.

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 10/31/06 3:50 PM, in article
1162327811.340887.212450@i42g2000cwa.googlegroups.com, "AAOO (Sean)"
<computer@startantra.net> wrote:

> Hi!, I have an auto update import on a access table, it works mostly
> ok, it update all user entered fields ok, but the fields that come up
[quoted text clipped - 12 lines]
> Peace and Love,
>   AAOO (Sean)

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.