I'm new to the whole MS SQL thing so please forgive me for the newb questions.
I have a access db on my laptop that I'm trying to figure out how to upload it into my ms sql db that I have hosted with the lunarpages.
Some methods I've found require the access db to be on the server and then you use ms enterprise manager to import it.
The other one, which seems like the only method I've found, is to recreate all the table structures by hand on the lunarpages serve then do a csv export from my access db and then import it into my table. Is there a way to export the sql and then just run that?