Access to SQL

<i><b>Originally posted by : loiler (wivina_lo@impiric.com.hk)</b></i><br />In my asp files, initally I was using a Microsoft Access database file for searching and editing records, but when many users try to edit the database at the same time, it crashed, so now I will have to switch to SQL. Is it possible to import an Access mdb to a SQL database? And what are the steps? Can anybody show me show useful websites in creating the SQL server as well as the other steps for switching to the SQL?

<i><b>Originally posted by : Jerry Scannell (JScannell1@home.com)</b></i><br /><br /><br /><br />------------<br />loiler at 3/23/2001 1:08:41 AM<br /><br />In my asp files, initally I was using a Microsoft Access database file for searching and editing records, but when many users try to edit the database at the same time, it crashed, so now I will have to switch to SQL. Is it possible to import an Access mdb to a SQL database? And what are the steps? Can anybody show me show useful websites in creating the SQL server as well as the other steps for switching to the SQL?<br /><br />I have performed Works to Access conversions in the past and this is what I did. It should work with your conversion. as well.<br /><br />First AND FOREMOST...Open each Access table in design view so you can write down all the field parameters. (name, data type, size, dec. pts., etc.) There are problems with modified properties once you import it into the new database engine.<br /><br />Then convert the Access tables to dBase (or csv or excel. dBase maintains the data type integrity for the most part. Excel and csv doesn't)<br /><br />Using the SQL command utility or GUI, create the database.<br /><br />One at a time, import your .dbf files using the SQL 7 GUI program.<br /><br />You will then have to edit each table to make sure the data field names, types, size, etc. are correct.<br />