Re: Exporting to SQL Server
What is your front end going to be to connect to SQL Server?
I have been using Excel for import/export, and that can be done via linked tables and VBA. The main issues I have had to deal with is the data itself - spelling errors, spelling variations (which means duplicate records in some cases), and if I'm trying to keep everything linked, the ID field numbers won't always match up with the new ID's in SQL Server, so I've had to create a quasi-random code to link the records to export/import.
So, it's not automated yet, but I hope to get there...
And, I'm with you on SSIS, barely getting my toes wet.
Life is not a problem to be solved, but a reality to experience.
Last edited by mjdemaris; 07-17-2019 at 11:46 AM.