• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Finally, you can manage your Google Docs, uploads, and email attachments (plus Dropbox and Slack files) in one convenient place. Claim a free account, and in less than 2 minutes, Dokkio (from the makers of PBworks) can automatically organize your content for you.



Page history last edited by PBworks 14 years, 11 months ago

Setting up an ODBC link


This is easy. It might not sound it; but it is.


Eventually we would like to replace the following description with a screencast. But for how now, here are some text and pictures. The thing to click is usually highlighted in blue in the picture.


Step 1: Click Start (the big green button usually on the bottom left of your screen)


Step 1a: Click "control Panel"



Step 2: Click the "administrative tools" icon.


Step 3: Click "Database sources (ODBC) Shortcut"


Step 4: In the "Create New Data Source" box, choose the source, in our example we have chosen "Microsoft Access Driver" but you could use a spreadsheet, or another database....


Step 5: In the "ODBC data source administrator box", click "Add".


Step 6: Choose a name for the data source, in the aptly named "Data Source Name" text box (we've called ours "GetDataIntoRExample"), and......


....Step 6a: Still on the same window as step 6, click "select" and seach your drive for wherever you filed your database, click on the database to select it.


Step 7: click "OK" lots of times!


Thats it! Now you can refer to the data source name in various programs (including R). Fantastic.

Comments (0)

You don't have permission to comment on this page.