Create data link using VBA

  • Thread starter Thread starter Stefan
  • Start date Start date
S

Stefan

Hello,

I created a database that read data from another system,
this beiing a CAD-system (Vertex). Now the access
database creates a table for every project in Vertex.
This means that The names of the tables and the amount
can vary. I created already the import routine using VBA
and also the queries are generated automatically. Now I
need to connect to the data using a different access
database file. Both are mdb-files version 2000. How do I
generate the connecion needed? Or is it only possible
when I use an SQL-server?
 
Thank you for the info, I will check if I can get it
working with this. Also thanks for the data-sources.

Stefan
 
Back
Top