Dynamic Import of CSV files with varying names

[Spezh]

I have had a good search around the forum, but can't find a solution to this one either. Any help, or links to a solution would be appreciated. I'm sure this must have been covered before somewhere.

The csv file with my daily orders (which I am trying to import using the transfertext in a module method) is generated at varying times through the day, and has a different name allocated automatically each time it is produced (though EDI software).

I am using buttons on a form to let inexperienced users import the files, but need to be able to give them the option to browse for the appropriate file each time they want to import.

The files are on our network, and always in the same folder.

Method?


Regards, and thanks in advance for any help.

Adam.

 

[badermsb]

Are the only CVS Files the one in the folder? What happens to the file once imported? You could write code that either would display the files for the user to select for importing or if once imported they are deleted, then just write the code to import all the CVS files currently in the folder.

 

[Spezh]

Other people use the csv files, so I have no control of how they look, or when they are deleted.

There may also be files in the same folder which I do not want to import. hence I want to give the user the option to browse for the file they need to import..

These things are never simple!

 

[badermsb]

If the amount of files is small, list them in a listbox and let the users pick & choose which ones to import... Or just write browse code behind the button. I'd be suprised if their is not an example of how to code it already in this forum. If not let me know and I'll post one tomorrow.

 

[The_Doc_Man]

Search this forum for older articles on the CommonControl ActiveX control, which includes color select, printer select, file select (for open) file location select (for save), etc... Also, Pat Hartman published some VBA code you could use to call out the FileOpen window. When you do the search, tell it "No time limit" on the age of the articles you wanted to see. I would publish it again myself except my notes aren't handy at the moment.

 

[Spezh]

Thanks guys. Will search further.

Adam.

 

[Spezh]

The search though the "Pat Hartman" archives has provided the perfect (and deliciously simple) solution.

Thanks for the help - would not have found it otherwise.


Now all I need to do is sort out the issue with importing blank columns

see: http://www.access-programmers.co.uk/forums/showthread.php?t=139114

so I can use the import properly.


Thanks again.

Adam.