This would require some serious thought. You'd have to analyze the structure of the Access table, convert this into CREATE TABLE statements, and then take all the data out of the Access DB & INSERT it into the SQL one.
The upsizing wizard in Access' tools menu is pretty easy to use & works well enough.
--Brian
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
A web based tool that will allow me to transfer data from Access to SQL Server would be brilliant!!!
This would require some serious thought. You'd have to analyze the structure of the Access table, convert this into CREATE TABLE statements, and then take all the data out of the Access DB & INSERT it into the SQL one.
The upsizing wizard in Access' tools menu is pretty easy to use & works well enough.
--Brian
Look at Tools --> Database Utilities --> Upsizing Wizard in Access.
It will do 90% of the work in converting from Access to SQL server for you!