I have an MS Access database, which I want to export as an MS SQL Server database. How is this done? I have Microsoft Access XP.
I notice that the "Export" feature doesn't work unless you select a table. Does that mean that I cannot export the entire database in one operation, but will need to export each table individually? What about the relationship between tables?
Also, I was told that Access XP has an "Export to SQL Server" feature. I didn't see that.