Can you export the data from WinAudit, can you export it as either a tab or csv type text file?
Can you import from that file type?
If you still see the same issue, open the exported text file with NotePad or WordPad and see if the data was exported or not.
You can make the same check with an export to xlsx files by opening the file with MS Excel to see if the data was ever exported.
It isn't possible to export the data from winaudit as either a tab or csv file.
As mentioned in the OP, the data is exporting just fine. Once I've exported to an access database, XML, or excel file, the data is there in the exported file, Filemaker just isn't acknowledging any of the text data.
If FileMaker isn't importing text, it didn't "export just fine". A text based export would have been a way to cross check how the data is exporting.
What is the structure and format of the text data when you export to excel? (What does it look like when you use Excel to open the file generated by the export?)
The text data when exported to excel has no special formatting. It's just listed as text. When I check the cell properties the cells are all formatted the same. The only exception to that is the very first entry which is bold and has a background color.
But what is the structure?
Do you see one row per record with each column containing the data you expect to import into separate fields of that record?
Keep in mind that I can't see what you see, but do know that importing data from Excel into Filemaker doesn't generally have this issue so I'm looking to see what's different about this data that might be a factor.
Yes, it's turning up as one record per row, with each column containing the appropriate data for the field it represents.
Can you upload a copy of that Excel file to a share site and post a download link here?
I realize the data may be sensitive. But I'd like to see that file to see if there are any issues with it. You wouldn't have to upload the whole file, just a copy with a few rows of data in it.
Here's what I did just as a test:
I created an excel spreadsheet and typed in data, text in some columns numbers in other.
I then imported the data into excel specifying the new table option so that this created a new table. The columns filled fields named f1, f2, f3... since I didn't type column headings into the spread sheet.
The numbers and text both imported without incident and the number fields thus created were of type number while the text fields were of type text.
I then deleted all the records and imported all the data without using the new table option. Once again I got all the numbers and text to import as I would expect.