Mikeyboi92
Registered User.
- Local time
- Today, 13:11
- Joined
- Aug 1, 2013
- Messages
- 10
Hi All,
I hope i have put this into the correct place. I gathered queries as i use a query to export my data.
Right, I have a slight issue that i cant seem to resolve.
I have created a database, it has a table that a query runs on. when the query is ran it looks for any records that have a 'true' value on a field called 'Management Escalation' it then exports all of these records to Excel and prompts you where to save it.
This is all working fine and it is exporting as it should be, the problem i have is Importing it Back into Access.
When i try to import it back into the table it was exported from i keep getting a message advising 43 records were deleted.
I have tried it just exporting then re-importing with no changes and i have the same issue. I tried changing one of the entries and re-import it to Access to see the change and again it failed and advised 43 records deleted and the original table was unchanged.
I have combo boxes / yes/no field / dates which i thought might be causing the issues but i have tried everything and its not working.
I can however import the excel back into Access using the create new table option and all the details are there and correct including the combo boxes etc.
Im soo confused, please can someone help me
:banghead:
Thank you !
Again sorry if this is in the wrong area..
I hope i have put this into the correct place. I gathered queries as i use a query to export my data.
Right, I have a slight issue that i cant seem to resolve.
I have created a database, it has a table that a query runs on. when the query is ran it looks for any records that have a 'true' value on a field called 'Management Escalation' it then exports all of these records to Excel and prompts you where to save it.
This is all working fine and it is exporting as it should be, the problem i have is Importing it Back into Access.
When i try to import it back into the table it was exported from i keep getting a message advising 43 records were deleted.
I have tried it just exporting then re-importing with no changes and i have the same issue. I tried changing one of the entries and re-import it to Access to see the change and again it failed and advised 43 records deleted and the original table was unchanged.
I have combo boxes / yes/no field / dates which i thought might be causing the issues but i have tried everything and its not working.
I can however import the excel back into Access using the create new table option and all the details are there and correct including the combo boxes etc.
Im soo confused, please can someone help me
:banghead:
Thank you !
Again sorry if this is in the wrong area..