Importing or linking to a *.CVM file

[JeffH13]

Curently I'm opening the CVM file in Access and exporting out the three
tables I need in the file to Access MDB file. This is time consuming and I
can't forget.

I was wondering if there is a way to link the table getting or create an
automatic exporting routen.

Thanks...

 

[John Nurick]

I've never encountered a CVM file and can't find any information on
them, but if you can open it in Access and export data to an MDB via the
user interface you can almost certainly open it using VBA. For instance,
the File|Export menu command with an MDB file as the destination
corresponds to the VBA method DoCmd.TransferDatabase.