Access->SQL convertion question

Results 1 to 3 of 3

Thread: Access->SQL convertion question

  1. #1
    dmitri Guest

    Default Access->SQL convertion question

    I have an Access Database working with my web-site, but i want to change to SQL. And i just dont know what to start with. Can somebody tell me how to do this. All i need is to convert all the data from my Access DB to SQL and change some code. The convertion is the trickiest part and i dont know how to do that. Please, help.

  2. #2
    BAM Guest

    Default RE: Access->SQL convertion question

    Run your Access db through the SQL upsize wizard and do a little clean up afterwards. Make sure all of your tables have primary keys set first or you will have to pick the keys as it converts each table.

  3. #3
    NPKumar Guest

    Default RE: Access->SQL convertion question

    Use DTS in SqlServer.Follow the folloowing steps:<BR>1.Create New Database on Sqlserver.<BR>2.Ridght click that database <BR>3.You will find AllTasks-&#062;RightClick-&#062;Import data .<BR>It will ask source and destination.<BR>U can do the remaining things.<BR>If You have any doubts pls mail at<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts