Results 1 to 2 of 2

Thread: Access to Sql

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Access to Sql

    I two tables that originally came from access but since my department has outgrown access, I am going to import the table from access to SQL then use access as the gui. My problem is I'm getting Timstamp errors and when it does import over the formatting is gone such as ss#'s. Also I was wondering is there a way that you can do queries in access without doing them in sql? (I'm still learning sql and sometimes my queries get error messages also)

    Can someone help pls

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    While a frequent SQL user might not like it much, the Access Upsizing Wizard sounds like just what you need! It makes the process pretty painless, and it will even build the Access Data Project files that will allow you to keep your formatting, etc.

    -PatP

Posting Permissions

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