I used to import an EDI file that was fixed width into VFoxpro. If I
remember correctly, the first 2 characters indicated the field type. We
would import that into a temp table. Let's call it tempTable1 and the
structure was:
CREATE TABLE tempTable1 (cFieldType C(2), cField1 C(200), cField2
C(200), cField3 C(200), etc.)
We would append it into these tables, and then split them out by type
after that point. Using SQL it was incredibly fast. I wonder if MySQL
could import it as:
CREATE TABLE tempTable1 (cFieldType Character(2), cField1 TEXT)
Just a thought.
-Kevin
On 11/06/2013 05:25 PM, MB Software Solutions General Account wrote:
MariaDB/MySQL backend
I'm trying to import some large (over 2GB) text files and on re-reading
the LOAD DATA INFILE function, it seems like it's only able to import
delimited records, not fixed width/position records.
Is there a way to do the import with fixed width and no delimiters? How
would you SQL Server dudes do it there?
tia,
--Mike
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
