access import with file name from excel
access import with file name from excel
(OP)
Hi,
Can anyone help, i need to import multiple Excel file to an access table, all the same fields, but when they import it adds the file name to a new colmun in the table...
The files are imported weekly, around 50-60 of them
Thanks in advance....
Can anyone help, i need to import multiple Excel file to an access table, all the same fields, but when they import it adds the file name to a new colmun in the table...
The files are imported weekly, around 50-60 of them
Thanks in advance....
RE: access import with file name from excel
All the parts you need should be there, just need to output to Access rather than Excel. Or use as-is and then move the resulting Excel to Access.
CODE --> VBA(excel)