I have an ASP.net application that is pulling data from Access databases using the JET provider. I have recently pushed this application to production and learned that there is not a 64 bit provider for connecting to an Access database.
These Access database files I am retrieving from (about 30 of them) are being dynamically generated every day. I am aware of the Upsizing wizard that Access provides, but it works very poorly and there is no way for me to automate this.
I have used the SQL Server Import and Export Wizard on a single Access database and it works quite well, but it seems to use the Jet Provider as well, so if there was a way to automate this, it wouldn't work on my 64 bit server.
Looking into an ODBC connection as a possible way to make a connection to an Access database, but this just seems to be a 'man in the middle' approach to my problem with a 32 bit provider like JET still being used.
After much research it seems as though there is not a 64 bit provider that can connect to Access. So I ask, can I programmatically upgrade an Access database to a SQL database on a 64 bit environment?