Re: Batch import excel files

Tech-Archive recommends: Fix windows errors by optimizing your registry

On May 9, 5:27 pm, Question Boy
<Question...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Would anyone have a good method to import a large number of standardized
excel files?

My boss finally saw the light, that individual workbooks do not give proper
oversight and now wants me to develop a small db to replace the workbooks.  
He also wants me to import all the existing information (1000+ spreadsheets).
 They are all setup the same way (layout).  How can I automate this task?  I
really cannot conceive doing this manually.

Thank you,

QB

Create an import specification to map the *** to a table in your
database. (one for each *** that goes into a different table). Then
once you have that, you can use Allen Browne's code to loop
directories and subdirectories and grab all the excel files using
DIR(). Then you would use TransferSpread*** if the import is easy.
Otherwise, you'd have to do something like create a query on an excel
file, and change the SQL in code and execute it. (Or use ADO). How's
that for a vague confusing answer?
.

Quantcast