Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] Frequently Asked Questions > Importing
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-03-2005, 10:52 AM
kevina kevina is online now
Registered User
 
Join Date: 03-27-2003
Posts: 825
How to import data from Access or other database?

In Access:
1) select the table to export
2) choose File | Export from the menu
-- choose Text files in the Save as type field
-- enter a filename
-- click Continue
3) select Delimited, click Next
4) select Comma in the delimiter field
-- check the 'include Field Names...' checkbox
-- use a Text Qualifier of " (double quote)
5) click Next
6) click Finish

Note: For other databases, use their CSV export capabilities to export tables to comma-delimited text files.

In Ultra Recall:
1) choose File | Import on the menu
2) choose 'A delimited text file (CSV)', click Next,
3) enter or browse to the file exported above
-- map any desired colums to Ultra Recall attributes (create any new attributes as necessary in Ultra Recall via the Attributes Editor button to map attributes not yet in Ultra Recall)
-- check 'Skip missing values'
-- check 'First row contains field names'
-- enter a Field Delimiter of , (comma)
-- enter a Text Qualifier of " (double quote)
-- choose an appropriate Template from the list
4) click Next, choose import location
5) click Finish

A separate item will be created in Ultra Recall for each record in the source table.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 01:11 PM.


Copyright © 1999-2023 Kinook Software, Inc.