Importing files

[afig]

I'm attempting to populate a table with contents from a file. I could simply use:

DoCmd.TransferText acImportDelim, , "tblImportData", "C:\Payments20051012.txt", False
DoCmd.OpenQuery "qryName"
DoCmd.DeleteObject acTable, "tblImportData"

but I'm attempting to make this as dummy-friendly as possible. I'd like to have an input element quite similar to html's <input type="file">, so that a user can just click the button, browse for the file, and click submit.

How could I go about doing this?

 

[Remou]

Have a look at this:
thread702-1342596

 

[afig]

I found the acCmdImport useful, but I'm unable to produce working script. I know I must be missing a few variables somewhere.

I keep getting "run-time error 2002". While searching msdn and the local help files I was unable to locate anything useful.

 

[Remou]

Please post all of the code in the procedure and mark the line that fails.

 

[afig]

I figured it out. apparently since the 2007 upgrade they did away with that macro (I should've known better, knowing m$), acCmdImportAttach is what I needed.

 

[afig]

is there some way to set import defaults, specifically field names and field types?