Importing multiple files to Access

[zaskodnik]

How do I import multiple Excel files (each containing only one sheet o
the same formatted information) to Access?
Is it easier to import some other file format?
Thank you,
Petr

 

[dandgard]

You can enter the names of the excel files in advance in a table and
then use a for loop in a VBA procedure to loop through the records in
the table and use the method transferspreadsheet to load the info from
the files.

The best way to transfer data is from another db that has odbc
capabilities. In other words you directly import the table to access.
Excel files can create problems and sometimes require manual working of
the cells to get them to transfer properly.

Text files can be easier to import but generally require more
programming knowledge to ensure that the integrity of the data is
intact.

 

[zaskodnik]

Thank you for your answer. I already created the form in Excel, so
have to use that. I don't know VBA. Is there a way to do it withou
knowledge of VBA?
Thank you. Or is there a way to process moltiple Excel files in Exce
instead of Access