Yes, it can, and relatively easy.
There are at least two ways: Create the table in SQL Server and then use SQL Server's Data Transformation Services to import your data. This way you have full control over the way the data is imported.
The other solution starts in Access:
1. Open your database
2. Choose Tools | Database Utilities | Upsize Wizard. You may be prompted for your Office CD to install the wizard.
3. The wizard is pretty straight forward. It asks for a database name, a SQL Server and the tables you want to convert.
4. I always disable the feature where Access adds Timestamps columns, but you should read the docs and see if you need them
5. Make sure that "Only create table structure" is not selected.
6. Finally, you get a chance to create a new project based on this database, or leave the Access database as is. You lost likely want the last option.
7. Once you're finished, Access will show a report indicating success or failure of the Upsize wizard.
If all went well, you now have your database in SQL Server.,
Cheers,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|
I have an Access database on the web with 30,000 plus records, and I would like to switch to SQL
