Linking and unlinking SQL data

Tags:
SQL
SQL View
How do link data from a SQL view?
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Not quite sure what your are referring to. Do you mean joining 2 selects into one statement with the UNION operation? Can you post a sample of the code so we can better understand?
    136,240 pointsBadges:
    report
  • Brijesh
    •    Open the destination database.
    • On the External Data tab, in the Import & Link group, click ODBC Database.
    •     Click Import the source data into a new table in the current database, and then click OK.
    •     In the Select Data Source dialog box, if the .dsn file that you want to use already exists, click the file in the list.
    • ShowI need to create a new .dsn file
    •     Click OK to close the Select Data Source dialog box.
    • Access displays the Import Objects dialog box.
    •     Under Tables, click each table or view that you want to import, and then click OK.
    •     If the Select Unique Record Identifier dialog box appears, Access was unable to determine which field or fields uniquely identify each row of a particular object. In this case, select the field or combination of fields that is unique for each row, and then click OK. If you are not sure, check with the SQL Server database administrator.
    • Access imports the data. If you plan to repeat the import operation later, you can save the import steps as an import specification and easily rerun the same import steps later. You require Microsoft Office Outlook installed on your computer to create a task.
    •     Click Close under Save Import Steps in the Get External Data - ODBC Database dialog box. Access finishes the import operation and displays the new table or tables in the Navigation Pane.
    14,450 pointsBadges:
    report
  • climber01
    I think you need to supply a bit more information on what you are trying to do please
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: