Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 396
Default Excel / Access Question

Good day all, i have a central database that our whole department uses
and i have a list of part number responsibility in it, which the users
update as and when required, my question is that i need to use the
latest list for a macro in excel, is it better to :-

a. Import external data, or
b. Do a look up from excel to the access table for the name and e-mail
address of the responsible buyer ?


Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default Excel / Access Question

What does the macro do?

MH

"Les Stout" wrote in message
...
Good day all, i have a central database that our whole department uses
and i have a list of part number responsibility in it, which the users
update as and when required, my question is that i need to use the
latest list for a macro in excel, is it better to :-

a. Import external data, or
b. Do a look up from excel to the access table for the name and e-mail
address of the responsible buyer ?


Best regards,

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access to Excel Question Bunky Excel Discussion (Misc queries) 2 March 1st 09 05:14 PM
Question about Excel & Access W. Excel Programming 1 July 26th 06 08:03 PM
Excel vs Access what art the question? PhilMontUSDA Excel Programming 10 July 23rd 05 09:07 PM
Excel to Access question Stuart[_5_] Excel Programming 2 April 27th 04 08:58 AM
Excel to Access Question Nonlinear Excel Programming 1 September 19th 03 09:46 PM


All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"