Hello,
I’m working on this program (Requisition program in access) that is replacing an Excel version. I’ve posted various questions related to this project already, but this is regarding the Excel program. We keep a history of parts and supplies in Excel (and now Access). I’ve been able to copy (import really) most of the history data into Access and normalize it, but that takes a lot of time and figuring out how to keep the history categorized by department, check for spelling errors, remove duplicates, remove trailing/leading spaces and apostrophes, etc.
Now, the time has come again to move more data into Access, because we just released the Access version for everyone (though it still has a few quirks). I have a few months’ worth of data that I’d like to move into Access. Each department has its own requisition history sheet.
We are in a networked, multi-user environment; I believe full permissions on network folders. (Don’t know if this makes any difference, but we use the MS domain/group policy stuff – sorry don’t know the correct wording.)
It took me a long time the first time I moved data over – mainly trying to normalize the incoming data and spelling errors!
And, no, we have not removed the Excel app from use, yet, just in case there was a major issue with the Access app.
My questions:
Is it easier to clean up the data in Excel, so that the import to Access is smoother?
Would it make sense to copy all data into one sheet first or not?
Would it make sense to create a connection to the Excel workbook, and use recordsets to import or copy the data? If so, what type of connection should I use?
What are some of the ways you guys have dealt with this?
Thank you again for your help!
I’m working on this program (Requisition program in access) that is replacing an Excel version. I’ve posted various questions related to this project already, but this is regarding the Excel program. We keep a history of parts and supplies in Excel (and now Access). I’ve been able to copy (import really) most of the history data into Access and normalize it, but that takes a lot of time and figuring out how to keep the history categorized by department, check for spelling errors, remove duplicates, remove trailing/leading spaces and apostrophes, etc.
Now, the time has come again to move more data into Access, because we just released the Access version for everyone (though it still has a few quirks). I have a few months’ worth of data that I’d like to move into Access. Each department has its own requisition history sheet.
We are in a networked, multi-user environment; I believe full permissions on network folders. (Don’t know if this makes any difference, but we use the MS domain/group policy stuff – sorry don’t know the correct wording.)
It took me a long time the first time I moved data over – mainly trying to normalize the incoming data and spelling errors!
And, no, we have not removed the Excel app from use, yet, just in case there was a major issue with the Access app.
My questions:
Is it easier to clean up the data in Excel, so that the import to Access is smoother?
Would it make sense to copy all data into one sheet first or not?
Would it make sense to create a connection to the Excel workbook, and use recordsets to import or copy the data? If so, what type of connection should I use?
What are some of the ways you guys have dealt with this?
Thank you again for your help!