Access Database to SQL Server

[james7705]

Can I convert my Access Database to an SQL server database?

[ranman256]

Upload all the tables to your SQL svr.
Split the database
Relink the access table to the SQL tables.
done.

[james7705]

What do I use to set up an SQL Server?

[ranman256]

You have to have some SQL server app (as Admin). That would let you in to make the tables.
Then run access append query to push the data there.

Unless the SQL app has an import tool, then just pick the table.