Linked Table Manager or Table Properties

  • Thread starter Thread starter Cheow Wang
  • Start date Start date
C

Cheow Wang

Hi,

In my VBA, I would like to retreive the info for the
Table Properties's Description. This table is actually
a linked table. How should I retrieve the following
info in my program?

Table Properties' Description :

Text;DSN=VATImport Unicode Specification;
FMT=Delimited;HDR=NO;IMEX=2;CharacterSet=1200;
DATABASE=D:\SAP Support\Shanghai VAT Project;
TABLE=VATImport - Unicode#txt

Thanks for any help!

Rgds,
Cheow Wang.
 
Make sure you have a reference set to DAO, and you'll be able to access that
using:

CurrentDb().TableDefs("MyTable").Connect

(replace "MyTable" with the actual name of the table)
 
Back
Top