import txt weekly txt files

[626]

I can import txt file manualy but I have weekly and daily txt files that are updates but every file ends with that weeks number (ie TEST52.txt) in trying to create a macro or VB that can give the end-user the ablity to choose which file they want to bring in and update the DB. If someone was any ideas that would be great.

Thanks

 

[Rolliee]

what do you mean 'bring in' and how is the txt file related to the mdb?

Rollie E

 

[626]

bring in: importing the txt files by fixed width. The txt files are updates to see status in processing new busines on a weekly and possible on daily status. The txt files are extracts from a main frame of a TPA (Third Party Administrator) who in turns FTP the txt files to me.

 

[Raptor136]

Try this. The user will still have to navigate to the area and select the type of file. Hope this helps -- Rap

Function Macro1()

DoCmd.RunCommand acCmdImport

End Function

 

[626]

Thanks