0

I want to create a link with MS-Access MDB database with a txt file via Delphi.

MSysIMEXSpecs and MSysIMEXColumns are system tables with link properties (column separator etc), but these tables are only created by Access assistant.

Is there a way to create these tables programmatically? (with ADO, ADOX, DAO, DDL...)

dbmitch
  • 5,361
  • 4
  • 24
  • 38
marciel.deg
  • 400
  • 3
  • 17
  • You can use `ADOQuery` to create a table – Ilyes Dec 03 '16 at 19:51
  • I can't create System Tables with ADOQuery. – marciel.deg Dec 04 '16 at 11:37
  • In MSAccess, there are 3 types of table (excluding links): TABLE, SYSTEM TABLE and ACCESS TABLE. TABLE are user-defined tables. SYSTEM TABLE has information of access internal controls (forms, relationships etc). ACCESS TABLE has extra info, and are not required in DB. MSysIMEXSpecs and MSysIMEXColumns are ACCESS TABLE. This information can be read in table properties via ADOX, but it's read-only. – marciel.deg Dec 04 '16 at 11:43
  • In VBA, I can call SysCmd (555) to generate these tables. But, I can't call it in Delphi – marciel.deg Dec 04 '16 at 11:54

0 Answers0