reading access database?.

Results 1 to 2 of 2

Thread: reading access database?.

  1. #1
    Join Date
    Dec 1969

    Default reading access database?.

    i have this idea in mind but don&#039t know if its possible.maybe one of you can tell me.i want to upload a access database and read through all the table names and use them in the sql statement to update another this possible?.if so, any ideas to help me start on this adventure?.

  2. #2
    Join Date
    Dec 1969

    Default RE: reading access database?.

    Well, here&#039s how you can get the table names (I think this is what you wanted)<BR><BR>dim cn, cat, tbl, tblarray(), ntbl<BR>Set cn = Server.CreateObject ("ADODB.Connection")<BR>Set cat = Server.CreateObject ("ADOX.Catalog")<BR>Set tbl = Server.CreateObject ("ADOX.Table")<BR>cn.ConnectionString = ...<BR>Set cat.ActiveConnection = cn<BR>redim tblarray (cat.tables.count)<BR>for each tbl in cat.tables<BR>tblarray (ntbl) =<BR>ntbl = ntbl + 1<BR>next<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts