Hey Folks
Hope you guys can give me a bit of advice here, a few years ago a developer sold the organisation an SQL server Database. This database is now seriously out of date and is harming our growth prospects. The developer had been contacted to make changes to it but has since vanished.
It's been a while since I last looked at Access but I know it will come back quickly if I go this route. Our organisation is small, 8 staff where only 2 or 3 would be accessing the database at the same time.
Since last year we updated our internal documents to gather marketing data and this data is going to waste as we have no way to record it in our client database.
Another big headache with the SQL database is the developer left it that the reports are throwaway .csv files and they are beyond the office staff even how to do a simple task like mail merge which as you can imagine leaves everything inefficient.
My question here is would I be better designing a new DB in access to gather all this data and somehow import the data from the .csv reports generated by the SQL database so we're not starting over or stick with SQL and hire a new developer which we cant really justify the cost in these hard times?
I have attached a sample database which contains the imported csv files structure (import tables) and some new tables I would use in an Access DB.
Queries have always been my weak point to say the lease, could someone please take a look and see if it is possible to import the data from the csv tables to the new ones and if so provide me a sample of a query that could do it?
Many thanks in advance for any insights you can provide.
Hope you guys can give me a bit of advice here, a few years ago a developer sold the organisation an SQL server Database. This database is now seriously out of date and is harming our growth prospects. The developer had been contacted to make changes to it but has since vanished.
It's been a while since I last looked at Access but I know it will come back quickly if I go this route. Our organisation is small, 8 staff where only 2 or 3 would be accessing the database at the same time.
Since last year we updated our internal documents to gather marketing data and this data is going to waste as we have no way to record it in our client database.
Another big headache with the SQL database is the developer left it that the reports are throwaway .csv files and they are beyond the office staff even how to do a simple task like mail merge which as you can imagine leaves everything inefficient.
My question here is would I be better designing a new DB in access to gather all this data and somehow import the data from the .csv reports generated by the SQL database so we're not starting over or stick with SQL and hire a new developer which we cant really justify the cost in these hard times?
I have attached a sample database which contains the imported csv files structure (import tables) and some new tables I would use in an Access DB.
Queries have always been my weak point to say the lease, could someone please take a look and see if it is possible to import the data from the csv tables to the new ones and if so provide me a sample of a query that could do it?
Many thanks in advance for any insights you can provide.