Importing Excel Data

[SteveE]

I have a DB that we import data from a spreadsheet every day. The spreadsheet can be of serval different names. I have a macro which can and does work well as long as the spreadsheet file is saved in the correct name.

Is there a way I can use a wildcard to select which file and which sheet within the file like the normal get external data / import routine?

also
I have split this DB into FE BE importing from within the full DB was always OK but now the "existing table" no longer shows so I cannot run the import routine from the FE, if I open the BE I can import as normal.


regards
Steve

 

[Shadez]

Its easily done in VBA,

filename = dir("c:\*.dat")
do
       call Process(filename)   'or what ever you do with the file
       filename = dir
       if filename = "" then
               exit do
       endif
loop