Recent content by txab

Yeah - that's the sticking point for me. The connection string works when I include the filename but fails without one. The issue is that the CSV filenames change every day and do not exhibit patterns like datetime stamps, etc.

Sorry per post #11. I don't want to use VBA for this scenario.

If I remove the filename following the bracket (like below), I get a "cannot find table" error. SELECT * INTO NewTable<br>FROM [Text;HDR=Yes;FMT=Delimited;Database=C:\Users\Daniel\Documents\Test] How should I proceed? Thank you!

Is it possible to use a wildcard in the filename here without resorting to VBA? My csv filenames change regularly but are always located in the same folder.