Recent content by jbdevon

That is possible, how ever I have not tried to import excel into yet another table. The reason for having excel file is if there is any data issue, it becomes easier to fix there, vs in Text file ( cumbersom to find trouble record ) or in Access where user may not have necessary skills. So...

Sure, I can delete the file, but what I am not getting is how/what is locking the file, even if i have deleted the temp table and refreshed the tabledef collection. this is really affecting the solution, because i have to implement this in 3 other similar processes. Thanks, JB

Hello Team, I am new here. I have one access db with few linked files ( excel and text ). The text file has over 100K rows ( detailed data ) , so I am using interim access table/query to group it and dump into Excel file, which is then again linked to a form in the same DB. ( Reason for this is...