Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Link table CSV DB with non standard extension

Status
Not open for further replies.

mobbarley

IS-IT--Management
Mar 4, 2004
22
0
0
AU
Hi,

I am trying to link a CSV text file table in access 2000. The file has an extension .log which cannot be changed. Access spits its dummy because of the extension. Is there a way around this?!

Regards,
John R.
 
Sorry guys, i know this is in the wrong forum. whoops. Does anyone have an answer?
 
You can use FileCopy in VB to copy the file at runtime (assuming that you do not want to change the extension on the original file).

Probably you will want to copy the file once manually, link it, then everytime you want to open a new version, use the above to copy and overwrite the previous version.

Thinking aloud here, never actually used it this way but I know FileCopy works great.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top