problems with . in the middle of filenames

noccy

Registered User.
Local time
Today, 17:05
Joined
Aug 19, 2003
Messages
67
Hello!

I use this code to import a list of text files to my db.

It works just fine, but not when the filenames had a . in the middle like 001.test.txt

Any suggestions on how to get by this problem?



Code:
For i = 0 To Me.Liste39.ListCount - 1

    varFile = Me.Liste39.ItemData(i)

    DoCmd.TransferText acImportDelim, "MySpec", "tblMyTable", varFile, HasFieldNames = False
Next i

liste39 is a listbox btw
 
Last edited by a moderator:

Users who are viewing this thread

Back
Top Bottom