I have a database which is split with the frontend (in Access 2010) and the backend on an SQL server in the cloud on Azure. Previous to this the database was completely on a server in house on Access 2010 only.
The old database ran a vba procedure which would take a range from an excel spreadsheet (the columns were always A-C but the rows could change) and import the data into a table.
I do not know how to import the excel info from the excel spreadsheet into a table on the Azure machine via a form on Access. Ideally I would like the user to see a form, press an import button, and the correct excel range would import into the table on the server. Then I could manipulate the data as I needed to.
In the old database I used DoCmd.TransferSpreadsheet acImport (Actually I had to run this chunk of code in a loop because the only way to tell I got to the bottom of the data was that the word TOTAL would appear in column A)
Any help is really appreciated.