Thankfully sql server has the handy upsizing wizard to export access to sql db And sql has SQL books on line
http://www.microsoft.com/sql/techinfo/productdoc/2000/default.asp Open your existing database inside of Access and choose Tools > Database Utilities > Upsizing Wizard. Once the wizard has started choose "Use existing database" and click "Next." You will then be asked to choose a data source. If you already have one set-up for your SQL account, you may select it here and skip to step eight. Go to the "Machine Data Source" tab and click New Choose a user or system data source depending on your security needs. Then select "SQL Server" from the list and click "Next" and "Finish." You will then be prompted for the SQL server information. the server is the IP address of your SQL server. On the next screen choose to login using "SQL Server Authentication." Enter your username and password for your SQL account and click "Next." Note: Be sure "TCP/IP" is selected in the "Client Configuration" Leave the next two screens at their default settings and click "Finish." This will pop-up a confirmation screen where you can test the data source. Once you have your data source created, make sure it is selected from the list and hit "OK." Enter your SQL password and hit "OK." You will then be asked which tables you want to convert to the new database. Move the tables you wish to convert into the window on the right and click "OK." Leave the remaining settings at their defaults unless you know you need to change them. Click "Finish." Hth - Paul -----Original Message----- From: Ian Westbrook (FDM) [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 14:32 To: CFUG List Subject: [ cf-dev ] Talking of SQL server... ...while we're on the subject of SQL server - I currently use Access, but sooner of later I'm going to gave to kick up to SQLserver. Are there any good online resources/introductory books to inform me about the migration of Access db to SQLserver and how to use/administer SQLserver? TIA Ian W --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 09/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 09/10/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
