Import Specification

[Cherilyn]

I currently have an automated process that I use a import
specification to import a text file. I created the import
spec after I had XP loaded. The import specification is
currently working great, however, I needed to update the
import specification and now it will no longer import my
file unless I save it as unicode first. The original spec
appears to have been created with a default page code and
has a 0 in the file type of MSysIMEXSpecs table and the
new spec now forces that I pick a code page in which I
chose unicode and it makes the MSysIMEXSpecs file type
1200. I have tried all the page code types and none are
0. Has anyone else had this type of problem? Do you know
how to set the file type in the MSysIMEXSpecs to 0? I
need to get this automated without an operator having to
open the file and save as unicode each time. Thanks in
advance to anyone who can help.

 

[Joe Fallon]

Cherilyn,
I just tried a couple of quick imports of dleimited ASCII files.
The first used code page OEM United States and had FileType = 437.
The second used ASCII code page and FileType = 20127.

Not sure what 0 means for File Type.

I use OEM United States code page since it is the default choice.
(Both imported the data the same way though.)

I suggest you print out the IMEX tables so you have the exact current state
of your specs.

Then you should edit the spec to add your fields, etc.

You should see if it works OK as is.
If so, you are done.

If not,
you can play with the IMEX tables.
Note: A direct edit of the tables fails. They are read only.
BUT - a query of the tables is Read/Write.
(Edit at your own risk. You may want to change the value back to 0.)

 

[Cherilyn]

Joe,
I did try the default OEM United States code page, but I'm
getting a message before and after selecting my import
spec that says "one or more rows of data in your file
contains too many characters to import max 65000". Isn't
this an indicator that the file type and file don't match?
Thank you for your help!
Cherilyn

 

[Joe Fallon]

Send me a copy of the data file and let me look at it.
Drop nospam from my email.