November 14, 200223 yr Newbies Hi, I'm having a problem importing an ascii comma file. When I try to import it, I am unable to specify by 'matching names'; It appears to be disabled. However, when I try importing an excel file, 'matching names' is enabled. I was originally using excel, but I have to import more than excel's column limit allows. What I need to do is be able to import a file with more than 256 columns and be able to at least map it correctly for the first run. Anyone know how I can do this?
November 14, 200223 yr When importing ASCII files, FM doesn't recognize any format for what might be interpreted as "Names". It would be useful if you could specify "use first record and field names" or such, but this type of operation is not supported. Excel allows such an option. In order to use the "matching names" option, you must import one of the file types that supports it (FileMaker, SYLK, DBF, etc.). -bd
November 15, 200223 yr Import it as a merge file. These are comma delimited, but use the first line for field names. You can select the "matching names" option with this format.
November 15, 200223 yr Author Newbies Importing as a merge file worked great - Thanks! Since the program I was extracting data from couldn't export merge files, I just used ascii comma and changed the extension.
Create an account or sign in to comment