Ok, this is more a general question regarding an Access Database built using SQL.... Can someone please advise me. Its's my understanding that in Access, you can manipulate data contained within fields by exporting the data to Excel, manipulating the
data contained within the fields and then cutting and pasting the data directly back into Access (providing none of the field parameters are changed, merely the data contained within the fields), so that the records are updated.
I want to know if this principle still applies if the Access Database has been written using SQL please?
Many thanks
View Complete Post