Hi,

I have a db which needs to use the exported report from a 3rd party application in a query. Every time the 3rd party application runs the report it exports a file to the root of c:, but unfortunately this doc is named .doc even though it is a csv. So, when I try to link to it, it kicks me out, as soon as I rename to .csv it is fine.

It is not practical to rename the file locally, as this file is also used by other applications too. So, does anyone know if there is a way or a setting to allow .doc to be a source for a linked table and if so, how do I do it?

Cheers all...

Does this help:

Public Sub ImportText()
  DoCmd.TransferText acImportDelim, , "TestQuery", "e:\My Documents\textforimport.doc"

End Sub

Best wishes,


Clive Astley

Hi,

   Your best bet is to confirm the existence of the file first, and then copy with the csv extension.

   This works in vbscript:

'======================================
Dim objFSO
Dim boolExists

Set objFSO = WScript.CreateObject("Scripting.FileSystemObject")

If IsObject(objFSO) Then
    boolExists = objFSO.FileExists("C:\Test.doc") 'returns -1 if file exists
End If

If boolExists = -1 Then
    objFSO.CopyFile "C:\Test.doc", "C:\Test.csv"
End If
'============================================

Of course once again I can't get it to work in VBA.

I hope this gets you started.


mmcdonal