Import hundreds of lists at once!

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1910
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Import hundreds of lists at once!

Post by Eric » Fri Nov 02, 2007 3:29 pm

This command allows you to import several files at once, combining all files into one database.

In order for this to work, all of your files will have to have the same field structure, and the files will have to be in the same directory.

Open one of your files in AccuZIP6 by pulling down the File menu to Open List. Assign field names to your data. Uncheck the Optimize, Find Dups, Validate, and Presort boxes. Uncheck the Parse boxes. Click Import.

Download this command:
AccuZIP6 5.0 Import Command
Unzip the command into the C:\Program Files (x86)\AccuZIP6 5.0 folder.

After downloading the appropriate command, back in AccuZIP6, pull down the Edit menu to Command. In the Save As box, give the command a name, such as Import Multiple Files. Paste the following command into the Command Statement Syntax area:

Code: Select all

DELETE ALL
PACK
=ImportFiles("*.xls","TYPE XL5")
In the example above, you would be importing several Excel files into the currently opened database. In this command, AccuZIP6 will automatically erase the records in the currently opened file, then it will begin importing all of the Excel files that are in the folder where the opened database resides.

You can change the last line of the command to import different types of files, in case you want to import a different format than xls.


To Import several Excel Files:

Code: Select all

=ImportFiles("*.xls","TYPE XL5")
To Import several DBF Files:

Code: Select all

=ImportFiles()
To Import several CSV Files:

Code: Select all

=ImportFiles("*.CSV","TYPE CSV")
To Import several Tab Delimited Text Files:

Code: Select all

=ImportFiles("*.TXT","TYPE DELIMITED WITH TAB")
To Import several Fixed Length (SDF) Files:

Code: Select all

=ImportFiles("*.SDF","TYPE SDF")

User avatar
Donna
Site Admin
Posts: 2733
Joined: Mon Mar 18, 2013 9:15 am

Importing mutiple files.

Post by Donna » Fri May 29, 2015 1:32 pm

This command works on files that have a header row.

Post Reply