View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shivboy[_5_] shivboy[_5_] is offline
external usenet poster
 
Posts: 1
Default Retreiving list of table & field names from Access into Excel using VBA


I am using VBA in MS Excel to create tables in MS Access and se
relationships between the tables as I have large amounts of relate
data. Now in order to do that, I need to know how to list the names o
the tables and fields in the tables in the database. This would help m
to choose tables and further choose fields in those tables to se
relationships between them. How do I do that? Please help.

Peace,

Shivbo

--
shivbo
-----------------------------------------------------------------------
shivboy's Profile: http://www.excelforum.com/member.php...fo&userid=3513
View this thread: http://www.excelforum.com/showthread.php?threadid=55160