Christopher Jeris
cjeris at fas.harvard.edu
Tue Apr 25 12:07:20 CDT 2006
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Access 2002 SP3 10.6501.6735, VBA 6.3 (6.4.9972). I have a fresh table [rowno] AutoNumber, [content] Memo I call DoCmd.TransferText acImportFixed, <specname>, <tablename>, <filename>, , , 65001 where <specname> names a specification which places each line of the input text file <filename> into the [content] field of <tablename>. It appears that the text file's lines are inserted in order, so that [rowno] forms a correct line numbering for the original text file (although the rows may not physically be in order by [rowno] = line number). Is this behavior (rows inserted in the same order they appear in the text file) guaranteed? If so, is this fact documented anywhere? I cannot find it. (The reason I'm doing this is that the input text file is encoded UTF-8, and if I use VBA Open/Line Input to get the text into strings, it appears to destroy my text by assuming the file is encoded ISO-8859-1 or Windows-1252 or something; if I use DoCmd.TransferText with CodePage = 65001 to pull it into a table and then open a recordset on the table, the encoding is transformed correctly. If you know an alternative solution to this problem, I would be grateful for that as well.) Thanks for your time, Chris Jeris - -- Christopher Jeris Web and Database Application Developer Harvard College Library, Widener G-10 cjeris at fas.harvard.edu / 617-495-2223 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFETldI5ICCNV0oGWARAjLDAJ9uRwd8aHV8qSqaw5y7PtC6j17GHQCglHHv wYdkhF6s3GGUVHfqu0iWvwE= =TVCG -----END PGP SIGNATURE-----