chrisaroundtown
Technical User
I have a macro that exports data from a form into an excel file. This works however when trying to import the same excel file back to an access table I am told the excel file is in the wrong format.
When I go into the excel file, after I save, I am told the excel file was made with a previous version of excel and would i like to update the format. Once clicking ok the excel file can be import back into access.
How do i get the access form to export in the correct format? Has anyone come across this?
Thanks
Chris
When I go into the excel file, after I save, I am told the excel file was made with a previous version of excel and would i like to update the format. Once clicking ok the excel file can be import back into access.
How do i get the access form to export in the correct format? Has anyone come across this?
Thanks
Chris
