Database Management FAQ : Database Export and Import : Import from Excel and Text Files

Related software (Read/Download) :
Organizer Deluxe Series
Organizer Pro Series

Question/Topic: How to import records from excel files?

Can I import my current inventory saved in Microsoft Excel into your software?

Save your Excel file as a text file (tab delimited).

  1. Start Excel and load your worksheet file you want to save for import into our program..
  2. On the File menu, Click Save As.
  3. In the File name box, type a name for your file.
  4. In the Save as type box, click Text (tab delimited).
  5. Important: Remember a folder where the text file was saved.
  6. Click Save.
  7. Check sample screen snapshots, listed after text instructions.

Import data from the text file into our program.

  1. Start our Organizer Deluxe and open/load the database to import the new records.
  2. On the Advanced menu, click Import.
  3. In the Import Source window select Text File and click OK.
  4. In the Import Options window select data fields that are in your text file. Important: only select the fields that are in your text file; selected fields have to be in the same order as they are in your text file.
  5. Click Import.
  6. Select your text file in the Enter/Select Import File window and click Open.
  7. Review imported record.

This is a sample worksheet in Microsoft Excel.

books worksheet

The above sample worksheet is saved as a text file (tab delimited): MyBooks.txt. Invisible tab character is between data fields.

text file, tab delimited

Organizer Deluxe, Import Options window. Important: the Fields Included box contains only fields that are in MyBooks.txt file. The order of the selected fields is the same as in the MyBooks.txt file.

Import Options window

Select Import File window. Select the MyBook.txt file. The file that was created from the Microsoft Excel program (text file, tab delimited).

select text file window

Related Topics ...
How to import database?

Related software (Read/Download) :
Organizer Deluxe Series
Organizer Pro Series

Copyright © PrimaSoft PC, Inc. All rights reserved.