View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Downloading Access database table into Excel (VB)

See also
http://www.rondebruin.nl/accessexcel.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
I don't have any familiarity with Access databases but have one that I need
to download and manipulate in Excel using Macros or VB within excel. Can
somone please help me with Excel VB code that will export a table from Access
to Excel.
Database name = Pressing.mdb (2000 file format)
Table name = Used Felt
Columns= "Mill Code", "Machine" and "Position" etc.
Thanks a bunch
Steve