Hello,
Looking for a easy / repeatable way of exporting data from Access to SQL server.
I can manually export an Access table to CSV say, and then use SQL Import tool to bring things into SQL server, but the SQL Import tool doesn't let you easily save preferences, layouts, etc. At least not in a user-friendly way. Has anyone done something in VBA that could help? Other suggestions (maybe 3rd party import tools?)
Looking for a easy / repeatable way of exporting data from Access to SQL server.
I can manually export an Access table to CSV say, and then use SQL Import tool to bring things into SQL server, but the SQL Import tool doesn't let you easily save preferences, layouts, etc. At least not in a user-friendly way. Has anyone done something in VBA that could help? Other suggestions (maybe 3rd party import tools?)