import text w/ 255+ fields

[rachael]

I'd like to import a text file with over 255 fields into Access. I know there is a limit to the number of fields a table can have, so is there any way I can do this? Would it be possible to import about 250 fields into one table, and the next 250 fields into another table? The import wizard only gives me access to the first 255 fields; I've tried skipping some fields from import, hoping I'd then be able to pull in additional fields, but it still only gives me access to the first 255. Is there anything I can do

Thank
Rachael

 

[Ken Snell]

You'll need to do the import programmatically by opening the text file,
reading the line into an array (assuming that the data are delimited by some
character) and then writing the desired data into fields of a recordset that
you open based on the table where the data are to be put. Something like
this:

Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim strLine As String
Dim varArray As Variant
' Replace the character in the next step with the actual delimiter that is
used in the text file
Const strDelimiter As String = "|"
Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset("TableName", dbOpenDynaset, dbAppendOnly)
Open "C:\MyFolder\MyTextFile.txt" For Input As #1
Do While EOF(1) = False
' read one line (record) from text file
Input #1, strLine
' split the line into an array
varArray = Split(strLine, strDelimiter)
rst.AddNew
' write the values into fields in the recordset using the desired array
elements
rst.Fields(0).Value = varArray(0)
rst.Fields(1).Value = varArray(3)
' etc. for all desired fields
rst.Update
Loop
rst.Close
Set rst = Nothing
dbs.Close
Set dbs = Nothing
Close #1

--
Ken Snell
<MS ACCESS MVP>

I'd like to import a text file with over 255 fields into Access. I know

there is a limit to the number of fields a table can have, so is there any
way I can do this? Would it be possible to import about 250 fields into one
table, and the next 250 fields into another table? The import wizard only
gives me access to the first 255 fields; I've tried skipping some fields
from import, hoping I'd then be able to pull in additional fields, but it
still only gives me access to the first 255. Is there anything I can do?

 

[John Nurick]

Hi Rachael,

Almost all files this wide contain many groups of repeating fields (e.g.
one per month) and will need to be massaged into a normalised structure
in several related tables once in Access.

I have a little utility that takes an wide textfile like this

Field1,Field2,Field3...
Value11,Value12,Value13...
Value21,Value22,Value23...

and turns it into a tall narrow one like this

RecNum,FieldName,FieldValue
1,Field1,Value11
1,Field2,Value12
1,Field3,Value13
....
2,Field1,Value21
2,Field2,Value22
2,Field3,Value23
....

which Access can easily import, after which you can query it directly to
analyse the data, or use append queries to move the data into a
normalised structure.

If this would help and you have Perl on your computer (or are willing to
install it), email me and I'll send it to you. (Remove the backwards
NoSpam from my email address.)

Alternatively, you could download the Gnu utilities from
http://unxutils.sourceforge.net/ . These include "cut", which can
extract selected fields from a textfile. You could use this to create
two textfiles each with fewer than 250 fields. However, it doesn't work
with with CSV files that contain commas in the fields.

Another approach is the one Ken suggests elsewhere in this thread. The
Split() function has the same problem with CSV files that have commas in
the fields, and of course you'd need to open two recordsets on two
tables, and put some of the fields in one and the rest in the other.

 

[rachael]

Thanks for the tips, Ken and John! For now, I'll play around with this and see what I can do. John's wide text utility sounds interesting. Since I'm not working on my own computer, I probably shouldn't install anything yet... but I'll definitely email you (John) if that looks like the best option

Thanks again for the help
Rachael

 

[rachael]

Ken

I tried playing around with the code you posted (thanks, btw). I'm getting a "subscript out of range" error on the following piece

Do While EOF(1) = Fals
' read one line (record) from text fil
Input #1, strLin
' split the line into an array (MY DELIMITER IS "~"
varArray = Split(strLine, strDelimiter
rst.AddNe
' write the values into fields in the recordset using the desired array element
rst.Fields(0).Value = varArray(0

**ERROR OCCURS HERE (FOR ANY ARRAY ELEMENT > 0)*
rst.Fields(1).Value = varArray(3

Shouldn't the number of elements in the array equal the number of substrings identified by the delimiter? In my case, that would be greater than 255. Why would I be getting a "subscript out of range" error

Also, I have a few fields that include commas (","). These are also being used as delimiters. For instance, the name "Smith, John" is being split into two separate records. Is there any way to avoid this?

Any thoughts/advice would be appreciated. Thanks
Rachael

 

[Ken Snell]

The error that you see indicates to me that your delimiter character is not
being recognized by the Split function and therefore the entire string is
being put into the varArray variable and thus it has just one element --
therefore, any reference to an element greater than zero will error.

Can you post some example lines of text from the text file that you're
trying to read? That will let me do some testing.

--
Ken Snell
<MS ACCESS MVP>

Ken,

I tried playing around with the code you posted (thanks, btw). I'm getting

a "subscript out of range" error on the following piece:

Do While EOF(1) = False
' read one line (record) from text file
Input #1, strLine
' split the line into an array (MY DELIMITER IS "~")
varArray = Split(strLine, strDelimiter)
rst.AddNew
' write the values into fields in the recordset using the desired array elements
rst.Fields(0).Value = varArray(0)

**ERROR OCCURS HERE (FOR ANY ARRAY ELEMENT > 0)**
rst.Fields(1).Value = varArray(3)


Shouldn't the number of elements in the array equal the number of

substrings identified by the delimiter? In my case, that would be greater
than 255. Why would I be getting a "subscript out of range" error?

Also, I have a few fields that include commas (","). These are also being

used as delimiters. For instance, the name "Smith, John" is being split into
two separate records. Is there any way to avoid this?

 

[Ken Snell]

BTW, just checking...

Did you change the line of code that defines what strDelimiter is?
Const strDelimiter As String = "|"

The above should be this in your code for your delimiter to work correctly.
Const strDelimiter As String = "~"

 

[rachael]

Thanks for taking a look at this. Below are 5 records of data (identifying information has been changed)

Student~PrsID~MAILID~InterID~Country~CareerL~CrsS5~CrsC5~SesC5~SesD5~EnrD5~ComD5~CanD5~CrsS6~CrsC6~SesC6~SesD6~EnrD6~ComD6~CanD6~CrsS7~CrsC7~SesC7~SesD7~EnrD7~ComD7~CanD7~CrsS8~CrsC8~SesC8~SesD8~EnrD8~ComD8~CanD8~CrsS9~CrsC9~SesC9~SesD9~EnrD9~ComD9~CanD9~CrsS10~CrsC10~SesC10~SesD10~EnrD10~ComD10~CanD10~CrsS11~CrsC11~SesC11~SesD11~EnrD11~ComD11~CanD11~A1~A12741~A12742~A12743~A12910~A12911~A12912~A12913~A12914~A12915~A12916~A12924~A12925~A12926~A12927~A12928~A12929~A12930~A12938~A12939~A12940~A12941~A12942~A2~A3~A38~A38472~A38473~A38474~A38520~A38521~A38522~A38596~A38600~A38629~A38671~A38672~A38673~A38709~A38710~A38714~A38731~A38762~A38777~A38778~A38887~A38892~A38928~A38945~A38946~A38947~A38966~A38967~A39~A39072~A39082~A39083~A39095~A39100~A39101~A39102~A39127~A39145~A39213~A39241~A39283~A39336~A39337~A39338~A39347~A39402~A39403~A39412~A39419~A39429~A39430~A39431~A39438~A39446~A39482~A39485~A39501~A39502~A39529~A39530~A39531~A39562~A39564~A39716~A39769~A39770~A39771~A39785~A39873~A39874~A39890~A39923~A39943~A39948~A39949~A39950~A39974~A39975~A4~A40~A40007~A40008~A40064~A40122~A40196~A40197~A40198~A40221~A40289~A41~A42~A43~A44~A45~A4501~A4502~A4503~A4504~A4505~A4506~A4507~A4508~A4509~A4510~A4511~A4512~A4513~A4514~A4515~A4516~A4517~A4518~A4519~A4520~A4521~A4522~A4523~A4524~A4525~A4526~A4527~A4528~A4529~A4530~A4531~A4532~A4533~A4534~A4535~A4536~A4537~A4538~A4539~A4540~A4541~A4542~A4543~A4544~A4545~A4546~A4547~A4548~A4549~A4550~A4551~A4552~A4553~A4554~A4555~A4556~A4557~A4558~A4559~A4560~A46~A47~A4716~A4717~A4763~A48~A4803~A4805~A4846~A4861~A49~A4908~A4963~A5~A50~A5045~A5048~A51~A5101~A5154~A5195~A52~A5244~A5291~A53~A5344~A5345~A5374~A54~A543~A5435~A544~A545~A546~A547~A548~A549~A55~A550~A551~A552~A553~A554~A555~A556~A557~A558~A559~A56~A560~A561~A562~A563~A564~A565~A566~A567~A568~A569~A57~A570~A571~A572~A573~A574~A575~A576~A577~A578~A579~A58~A580~A581~A582~A583~A584~A585~A586~A587~A588~A589~A59~A590~A591~A592~A593~A594~A595~A596~A597~A598~A599~A6~A60~A600~A601~A602~A603~A604~A605~A606~A607~A608~A609~A61~A610~A611~A612~A613~A614~A615~A616~A617~A618~A619~A620~A621~A622~A623~A624~A625~A626~A627~A628~A629~A630~A631~A632~A633~A634~A635~A636~A637~A638~A639~A640~A641~A642~A643~A644~A645~A646~A647~A648~A649~A650~A651~A65
Hope, Bob~100037305 [email protected]~100080~Belgium~Consultant ~Completed ~TZ325 ~03-1663 ~08/18/2003~05/27/2003~08/22/2003~~Enrolled ~630699 ~~~07/11/2003~~~Completed ~X000551 ~~~04/28/2003~05/16/2003~~Enrolled ~SFPROJ01E ~~~01/02/2004~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~5~~~~~~~~4~~~~~~~~~~~~~~~~~~~~~4~~~~~~~~~~~~~~~~~4~~~~~~~5~~~~~~~~~~~~~~~~~~~5~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~3~3~3~5~3~4~4~4~5~5~5~4~4~4~4~4~4~4~5~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~5~5~5~5~5~5~5~4~4~~4~4~4~4~4~3~1~5~5~~~~~~~~~~~~~~~~~~~~~~~~~2~2~3~1~1~1~1~3~1~2~2~1~1~2~1~1~3~1~4~2~1~1~2~1~4~4~1~~~~~
Kangaroo, Captain~000171370 [email protected]~10080~United States~Consultant ~Completed ~TZ325 ~03-2341 ~11/17/2003~09/05/2003~11/21/2003~~Completed ~630699 ~~~06/09/2003~06/12/2003~~Completed ~X000551 ~~~04/28/2003~09/02/2003~~Completed ~SFPROJ01E ~~~04/07/2003~06/12/2003~~~~~~~~~~~~~~~~~~~~~~~~5~~3~5~5~5~5~5~5~5~5~5~5~5~5~5~5~5~5~5~5~5~~~~5~~~~~~~5~~~~~~~5~~4~~~5~~5~~~~~~~~5~5~5~~~~~3~4~~5~~~~~~~5~5~~~~5~5~~~~~~~~~~5~~~~5~~~~5~5~~~~~~~~~4~5~~~~~5~5~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~2~4~4~~~4~~~~~4~4~5~5~~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~1~2~3~1~1~2~1~2~1~2~~1~1~2~2~1~1~3~1~1~1~~2~1~1~2~1~4~1~3~4~5~~4~~~~~~~~~~~~~~~~5~1~5~4~~~~~~~~~~~~~~~~~~~~~~~~~1~2~3~1~1~2~1~3~2~1~1~1~2~2~1~2~4~3~1~2~2~1~2~1~1~3~1~5~4~4~4~3~
Jojo, Joey~000173370 [email protected]~10140~United States~Consultant ~Completed ~TZ325 ~03-1656 ~06/09/2003~02/19/2003~06/13/2003~~~~~~~~~Enrolled ~X000551 ~~~04/28/2003~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~4~3~4~3~3~4~4~4~4~~5~4~5~4~5~4~5~3~4~2~~~3~2~4~2~4~4~2~3~3~3~~4~3~4~3~4~4~4~4~2~2~1~2~3~1~1~2~1~3~2~2~1~1~1~2~2~2~3~4~4~1~2~1~2~1~4~4~3~~~~~
Tufnel, Nigel~100039625 [email protected]~101440~United Kingdom~Consultant ~Completed ~TZ325 ~03-1959 ~10/06/2003~09/13/2003~10/10/2003~~Enrolled ~630699 ~~~10/01/2003~~~Enrolled ~X000551 ~~~04/28/2003~~~Enrolled ~SFPROJ01E ~~~10/01/2003~~~Enrolled ~MSF201825 ~~~10/02/2003~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~5~4~4~5~4~~~~~~~~4~4~~~~~~~~~~~~~~4~~~4~4~4~~~~~~~~~~~4~~~~5~4~~~~~~~~4~4~4~~~~~~~~~~4~~5~~~~4~4~4~~~~~~4~~~~~4~~~~~~~4~~~~~~~~~~~~~4~4~4~4~4~4~4~4~4~4~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~4~2~5~3~~~~~~~~~~~~~~~~~~~~~~~~~4~2~3~1~1~2~1~3~1~1~1~2~1~2~1~2~3~1~1~2~2~1~3~1~1~3~1~~~~~~
Bird, Big~000170038 [email protected]~10150~United States~Consultant ~Completed ~TZ325 ~04-0025 ~02/09/2004~01/16/2004~02/13/2004~~Completed ~630699 ~~~02/02/2004~02/05/2004~~Completed ~X000551 ~~~04/28/2003~07/12/2003~~Completed ~SFPROJ01E ~~~12/08/2003~12/08/2003~~Completed ~MSF201825 ~~~02/02/2004~02/03/2004~~Completed ~MSF201849 ~~~02/02/2004~02/03/2004~~Completed ~MSF201850 ~~~02/03/2004~02/03/2004~~~~4~3~5~5~5~5~5~5~5~4~4~4~4~4~4~4~4~4~4~4~4~~~~4~~~~~~~5~~~~~~~~4~4~~~4~~4~~~~~~~~4~5~5~~~~~3~4~~4~~~~~~~4~4~~~~5~5~~~~~~~~~~4~~~~4~~~~4~5~~~~~~~~~4~5~~~~~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~4~4~~4~~4~~~~~~4~4~4~~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~3~2~3~2~2~2~4~3~2~1~~1~1~2~2~2~2~1~3~2~1~~2~1~1~1~1~4~4~2~1~5~~5~~~~~~~~~~~~~~~~4~1~5~2~~~~~~~~~~~~~~~~~~~~~~~~~4~2~3~1~1~2~1~3~2~2~1~1~2~1~2~1~3~3~1~2~2~1~2~1~4~3~1~~~~~~

 

[rachael]

Yep, I double-checked the string delimiter code, and I did change it to "~".

 

[Ken Snell]

Newsreader is linewrapping and I cannot tell where one record ends and
another begins.

Can you email a copy of these records to me (remove this is not real from my
email address).

Also, post here the full code that you're now trying to use.

--
Ken Snell
<MS ACCESS MVP>

Thanks for taking a look at this. Below are 5 records of data (identifying information has been changed):

Student~PrsID~MAILID~InterID~Country~CareerL~CrsS5~CrsC5~SesC5~SesD5~EnrD5~C
omD5~CanD5~CrsS6~CrsC6~SesC6~SesD6~EnrD6~ComD6~CanD6~CrsS7~CrsC7~SesC7~SesD7
~EnrD7~ComD7~CanD7~CrsS8~CrsC8~SesC8~SesD8~EnrD8~ComD8~CanD8~CrsS9~CrsC9~Ses
C9~SesD9~EnrD9~ComD9~CanD9~CrsS10~CrsC10~SesC10~SesD10~EnrD10~ComD10~CanD10~
CrsS11~CrsC11~SesC11~SesD11~EnrD11~ComD11~CanD11~A1~A12741~A12742~A12743~A12
910~A12911~A12912~A12913~A12914~A12915~A12916~A12924~A12925~A12926~A12927~A1
2928~A12929~A12930~A12938~A12939~A12940~A12941~A12942~A2~A3~A38~A38472~A3847
3~A38474~A38520~A38521~A38522~A38596~A38600~A38629~A38671~A38672~A38673~A387
09~A38710~A38714~A38731~A38762~A38777~A38778~A38887~A38892~A38928~A38945~A38
946~A38947~A38966~A38967~A39~A39072~A39082~A39083~A39095~A39100~A39101~A3910
2~A39127~A39145~A39213~A39241~A39283~A39336~A39337~A39338~A39347~A39402~A394
03~A39412~A39419~A39429~A39430~A39431~A39438~A39446~A39482~A39485~A39501~A39
502~A39529~A39530~A39531~A39562~A39564~A39716~A39769~A39770~A39771~A39785~A3
9873~A39874~A39890~A39923~A39943~A39948~A39949~A39950~A39974~A39975~A4~A40~A
40007~A40008~A40064~A40122~A40196~A40197~A40198~A40221~A40289~A41~A42~A43~A4
4~A45~A4501~A4502~A4503~A4504~A4505~A4506~A4507~A4508~A4509~A4510~A4511~A451
2~A4513~A4514~A4515~A4516~A4517~A4518~A4519~A4520~A4521~A4522~A4523~A4524~A4
525~A4526~A4527~A4528~A4529~A4530~A4531~A4532~A4533~A4534~A4535~A4536~A4537~
A4538~A4539~A4540~A4541~A4542~A4543~A4544~A4545~A4546~A4547~A4548~A4549~A455
0~A4551~A4552~A4553~A4554~A4555~A4556~A4557~A4558~A4559~A4560~A46~A47~A4716~
A4717~A4763~A48~A4803~A4805~A4846~A4861~A49~A4908~A4963~A5~A50~A5045~A5048~A
51~A5101~A5154~A5195~A52~A5244~A5291~A53~A5344~A5345~A5374~A54~A543~A5435~A5
44~A545~A546~A547~A548~A549~A55~A550~A551~A552~A553~A554~A555~A556~A557~A558
~A559~A56~A560~A561~A562~A563~A564~A565~A566~A567~A568~A569~A57~A570~A571~A5
72~A573~A574~A575~A576~A577~A578~A579~A58~A580~A581~A582~A583~A584~A585~A586
~A587~A588~A589~A59~A590~A591~A592~A593~A594~A595~A596~A597~A598~A599~A6~A60
~A600~A601~A602~A603~A604~A605~A606~A607~A608~A609~A61~A610~A611~A612~A613~A
614~A615~A616~A617~A618~A619~A620~A621~A622~A623~A624~A625~A626~A627~A628~A6
29~A630~A631~A632~A633~A634~A635~A636~A637~A638~A639~A640~A641~A642~A643~A64
4~A645~A646~A647~A648~A649~A650~A651~A652
Hope, Bob~100037305 [email protected]~100080~Belgium~Consultant

~Completed ~TZ325 ~03-1663
~08/18/2003~05/27/2003~08/22/2003~~Enrolled ~630699
~~~07/11/2003~~~Completed ~X000551
~~~04/28/2003~05/16/2003~~Enrolled ~SFPROJ01E
~~~01/02/2004~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~5~~~~
~~~~4~~~~~~~~~~~~~~~~~~~~~4~~~~~~~~~~~~~~~~~4~~~~~~~5~~~~~~~~~~~~~~~~~~~5~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~3~3~3~5~3~4~4~4~5~5~5~4~4~4
~4~4~4~4~5~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~5~5~5~5~5~5~5~4~4~~4~4~4~4~4~3~1~5~5~~~~~~~~~~~~~~~~~~~~~~~~~2~2~
3~1~1~1~1~3~1~2~2~1~1~2~1~1~3~1~4~2~1~1~2~1~4~4~1~~~~~~

Kangaroo, Captain~000171370 [email protected]~10080~United

States~Consultant ~Completed ~TZ325
~03-2341 ~11/17/2003~09/05/2003~11/21/2003~~Completed
~630699 ~~~06/09/2003~06/12/2003~~Completed ~X000551
~~~04/28/2003~09/02/2003~~Completed ~SFPROJ01E
~~~04/07/2003~06/12/2003~~~~~~~~~~~~~~~~~~~~~~~~5~~3~5~5~5~5~5~5~5~5~5~5~5~5
~5~5~5~5~5~5~5~~~~5~~~~~~~5~~~~~~~5~~4~~~5~~5~~~~~~~~5~5~5~~~~~3~4~~5~~~~~~~
5~5~~~~5~5~~~~~~~~~~5~~~~5~~~~5~5~~~~~~~~~4~5~~~~~5~5~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~2~4~4~~~4~~~~~4~4~5~5~~4~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~1~2~3~1~1~2~1~2~1~2~~1~1~2~2~1~1~3~1~1~1~~2~1~1~2~1~4~1~3~4~5~
~4~~~~~~~~~~~~~~~~5~1~5~4~~~~~~~~~~~~~~~~~~~~~~~~~1~2~3~1~1~2~1~3~2~1~1~1~2~
2~1~2~4~3~1~2~2~1~2~1~1~3~1~5~4~4~4~3~5

Jojo, Joey~000173370 [email protected]~10140~United

States~Consultant ~Completed ~TZ325 ~03-1656
~06/09/2003~02/19/2003~06/13/2003~~~~~~~~~Enrolled ~X000551
~~~04/28/2003~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~4~3~4~3~3
~4~4~4~4~~5~4~5~4~5~4~5~3~4~2~~~3~2~4~2~4~4~2~3~3~3~~4~3~4~3~4~4~4~4~2~2~1~2
~3~1~1~2~1~3~2~2~1~1~1~2~2~2~3~4~4~1~2~1~2~1~4~4~3~~~~~~

Tufnel, Nigel~100039625 [email protected]~101440~United

Kingdom~Consultant ~Completed ~TZ325
~03-1959 ~10/06/2003~09/13/2003~10/10/2003~~Enrolled
~630699 ~~~10/01/2003~~~Enrolled ~X000551
~~~04/28/2003~~~Enrolled ~SFPROJ01E
~~~10/01/2003~~~Enrolled ~MSF201825
~~~10/02/2003~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~5~4~4~5~4~~~~~~~~4~4~~~~~~~~
~~~~~~4~~~4~4~4~~~~~~~~~~~4~~~~5~4~~~~~~~~4~4~4~~~~~~~~~~4~~5~~~~4~4~4~~~~~~
4~~~~~4~~~~~~~4~~~~~~~~~~~~~4~4~4~4~4~4~4~4~4~4~4~4~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~4~2~5~3~~~~~~~~~~~~~~~~~~~~~~~~~4~2~3~1~1~2~1~3
~1~1~1~2~1~2~1~2~3~1~1~2~2~1~3~1~1~3~1~~~~~~

Bird, Big~000170038 [email protected]~10150~United States~Consultant

~Completed ~TZ325 ~04-0025
~02/09/2004~01/16/2004~02/13/2004~~Completed ~630699
~~~02/02/2004~02/05/2004~~Completed ~X000551
~~~04/28/2003~07/12/2003~~Completed ~SFPROJ01E
~~~12/08/2003~12/08/2003~~Completed ~MSF201825
~~~02/02/2004~02/03/2004~~Completed ~MSF201849
~~~02/02/2004~02/03/2004~~Completed ~MSF201850
~~~02/03/2004~02/03/2004~~~~4~3~5~5~5~5~5~5~5~4~4~4~4~4~4~4~4~4~4~4~4~~~~4~~
~~~~~5~~~~~~~~4~4~~~4~~4~~~~~~~~4~5~5~~~~~3~4~~4~~~~~~~4~4~~~~5~5~~~~~~~~~~4
~~~~4~~~~4~5~~~~~~~~~4~5~~~~~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~4~4~~4~~4~~~~~~4~4~4~~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~3~2~3~2
~2~2~4~3~2~1~~1~1~2~2~2~2~1~3~2~1~~2~1~1~1~1~4~4~2~1~5~~5~~~~~~~~~~~~~~~~4~1
~5~2~~~~~~~~~~~~~~~~~~~~~~~~~4~2~3~1~1~2~1~3~2~2~1~1~2~1~2~1~3~3~1~2~2~1~2~1
~4~3~1~~~~~~

 

[Ken Snell]

Found the problem...and it's my error!

Change
Input #1, strLine

to
Line Input #1, strLine


Input will read to a "comma" delimiter. Line Input will read the entire
line.

That should fix the code for you!

--
Ken Snell
<MS ACCESS MVP>

Thanks for taking a look at this. Below are 5 records of data (identifying information has been changed):

Student~PrsID~MAILID~InterID~Country~CareerL~CrsS5~CrsC5~SesC5~SesD5~EnrD5~C
omD5~CanD5~CrsS6~CrsC6~SesC6~SesD6~EnrD6~ComD6~CanD6~CrsS7~CrsC7~SesC7~SesD7
~EnrD7~ComD7~CanD7~CrsS8~CrsC8~SesC8~SesD8~EnrD8~ComD8~CanD8~CrsS9~CrsC9~Ses
C9~SesD9~EnrD9~ComD9~CanD9~CrsS10~CrsC10~SesC10~SesD10~EnrD10~ComD10~CanD10~
CrsS11~CrsC11~SesC11~SesD11~EnrD11~ComD11~CanD11~A1~A12741~A12742~A12743~A12
910~A12911~A12912~A12913~A12914~A12915~A12916~A12924~A12925~A12926~A12927~A1
2928~A12929~A12930~A12938~A12939~A12940~A12941~A12942~A2~A3~A38~A38472~A3847
3~A38474~A38520~A38521~A38522~A38596~A38600~A38629~A38671~A38672~A38673~A387
09~A38710~A38714~A38731~A38762~A38777~A38778~A38887~A38892~A38928~A38945~A38
946~A38947~A38966~A38967~A39~A39072~A39082~A39083~A39095~A39100~A39101~A3910
2~A39127~A39145~A39213~A39241~A39283~A39336~A39337~A39338~A39347~A39402~A394
03~A39412~A39419~A39429~A39430~A39431~A39438~A39446~A39482~A39485~A39501~A39
502~A39529~A39530~A39531~A39562~A39564~A39716~A39769~A39770~A39771~A39785~A3
9873~A39874~A39890~A39923~A39943~A39948~A39949~A39950~A39974~A39975~A4~A40~A
40007~A40008~A40064~A40122~A40196~A40197~A40198~A40221~A40289~A41~A42~A43~A4
4~A45~A4501~A4502~A4503~A4504~A4505~A4506~A4507~A4508~A4509~A4510~A4511~A451
2~A4513~A4514~A4515~A4516~A4517~A4518~A4519~A4520~A4521~A4522~A4523~A4524~A4
525~A4526~A4527~A4528~A4529~A4530~A4531~A4532~A4533~A4534~A4535~A4536~A4537~
A4538~A4539~A4540~A4541~A4542~A4543~A4544~A4545~A4546~A4547~A4548~A4549~A455
0~A4551~A4552~A4553~A4554~A4555~A4556~A4557~A4558~A4559~A4560~A46~A47~A4716~
A4717~A4763~A48~A4803~A4805~A4846~A4861~A49~A4908~A4963~A5~A50~A5045~A5048~A
51~A5101~A5154~A5195~A52~A5244~A5291~A53~A5344~A5345~A5374~A54~A543~A5435~A5
44~A545~A546~A547~A548~A549~A55~A550~A551~A552~A553~A554~A555~A556~A557~A558
~A559~A56~A560~A561~A562~A563~A564~A565~A566~A567~A568~A569~A57~A570~A571~A5
72~A573~A574~A575~A576~A577~A578~A579~A58~A580~A581~A582~A583~A584~A585~A586
~A587~A588~A589~A59~A590~A591~A592~A593~A594~A595~A596~A597~A598~A599~A6~A60
~A600~A601~A602~A603~A604~A605~A606~A607~A608~A609~A61~A610~A611~A612~A613~A
614~A615~A616~A617~A618~A619~A620~A621~A622~A623~A624~A625~A626~A627~A628~A6
29~A630~A631~A632~A633~A634~A635~A636~A637~A638~A639~A640~A641~A642~A643~A64
4~A645~A646~A647~A648~A649~A650~A651~A652
Hope, Bob~100037305 [email protected]~100080~Belgium~Consultant

~Completed ~TZ325 ~03-1663
~08/18/2003~05/27/2003~08/22/2003~~Enrolled ~630699
~~~07/11/2003~~~Completed ~X000551
~~~04/28/2003~05/16/2003~~Enrolled ~SFPROJ01E
~~~01/02/2004~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~5~~~~
~~~~4~~~~~~~~~~~~~~~~~~~~~4~~~~~~~~~~~~~~~~~4~~~~~~~5~~~~~~~~~~~~~~~~~~~5~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~3~3~3~5~3~4~4~4~5~5~5~4~4~4
~4~4~4~4~5~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~5~5~5~5~5~5~5~4~4~~4~4~4~4~4~3~1~5~5~~~~~~~~~~~~~~~~~~~~~~~~~2~2~
3~1~1~1~1~3~1~2~2~1~1~2~1~1~3~1~4~2~1~1~2~1~4~4~1~~~~~~

Kangaroo, Captain~000171370 [email protected]~10080~United

States~Consultant ~Completed ~TZ325
~03-2341 ~11/17/2003~09/05/2003~11/21/2003~~Completed
~630699 ~~~06/09/2003~06/12/2003~~Completed ~X000551
~~~04/28/2003~09/02/2003~~Completed ~SFPROJ01E
~~~04/07/2003~06/12/2003~~~~~~~~~~~~~~~~~~~~~~~~5~~3~5~5~5~5~5~5~5~5~5~5~5~5
~5~5~5~5~5~5~5~~~~5~~~~~~~5~~~~~~~5~~4~~~5~~5~~~~~~~~5~5~5~~~~~3~4~~5~~~~~~~
5~5~~~~5~5~~~~~~~~~~5~~~~5~~~~5~5~~~~~~~~~4~5~~~~~5~5~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~2~4~4~~~4~~~~~4~4~5~5~~4~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~1~2~3~1~1~2~1~2~1~2~~1~1~2~2~1~1~3~1~1~1~~2~1~1~2~1~4~1~3~4~5~
~4~~~~~~~~~~~~~~~~5~1~5~4~~~~~~~~~~~~~~~~~~~~~~~~~1~2~3~1~1~2~1~3~2~1~1~1~2~
2~1~2~4~3~1~2~2~1~2~1~1~3~1~5~4~4~4~3~5

Jojo, Joey~000173370 [email protected]~10140~United

States~Consultant ~Completed ~TZ325 ~03-1656
~06/09/2003~02/19/2003~06/13/2003~~~~~~~~~Enrolled ~X000551
~~~04/28/2003~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~4~3~4~3~3
~4~4~4~4~~5~4~5~4~5~4~5~3~4~2~~~3~2~4~2~4~4~2~3~3~3~~4~3~4~3~4~4~4~4~2~2~1~2
~3~1~1~2~1~3~2~2~1~1~1~2~2~2~3~4~4~1~2~1~2~1~4~4~3~~~~~~

Tufnel, Nigel~100039625 [email protected]~101440~United

Kingdom~Consultant ~Completed ~TZ325
~03-1959 ~10/06/2003~09/13/2003~10/10/2003~~Enrolled
~630699 ~~~10/01/2003~~~Enrolled ~X000551
~~~04/28/2003~~~Enrolled ~SFPROJ01E
~~~10/01/2003~~~Enrolled ~MSF201825
~~~10/02/2003~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~5~4~4~5~4~~~~~~~~4~4~~~~~~~~
~~~~~~4~~~4~4~4~~~~~~~~~~~4~~~~5~4~~~~~~~~4~4~4~~~~~~~~~~4~~5~~~~4~4~4~~~~~~
4~~~~~4~~~~~~~4~~~~~~~~~~~~~4~4~4~4~4~4~4~4~4~4~4~4~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~4~2~5~3~~~~~~~~~~~~~~~~~~~~~~~~~4~2~3~1~1~2~1~3
~1~1~1~2~1~2~1~2~3~1~1~2~2~1~3~1~1~3~1~~~~~~

Bird, Big~000170038 [email protected]~10150~United States~Consultant

~Completed ~TZ325 ~04-0025
~02/09/2004~01/16/2004~02/13/2004~~Completed ~630699
~~~02/02/2004~02/05/2004~~Completed ~X000551
~~~04/28/2003~07/12/2003~~Completed ~SFPROJ01E
~~~12/08/2003~12/08/2003~~Completed ~MSF201825
~~~02/02/2004~02/03/2004~~Completed ~MSF201849
~~~02/02/2004~02/03/2004~~Completed ~MSF201850
~~~02/03/2004~02/03/2004~~~~4~3~5~5~5~5~5~5~5~4~4~4~4~4~4~4~4~4~4~4~4~~~~4~~
~~~~~5~~~~~~~~4~4~~~4~~4~~~~~~~~4~5~5~~~~~3~4~~4~~~~~~~4~4~~~~5~5~~~~~~~~~~4
~~~~4~~~~4~5~~~~~~~~~4~5~~~~~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~4~4~~4~~4~~~~~~4~4~4~~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~3~2~3~2
~2~2~4~3~2~1~~1~1~2~2~2~2~1~3~2~1~~2~1~1~1~1~4~4~2~1~5~~5~~~~~~~~~~~~~~~~4~1
~5~2~~~~~~~~~~~~~~~~~~~~~~~~~4~2~3~1~1~2~1~3~2~2~1~1~2~1~2~1~3~3~1~2~2~1~2~1
~4~3~1~~~~~~

 

[rachael]

Below is the code. Since I was first just trying it out to see how it worked, I didn't include all of the fields. I'm emailing you the sample data

Private Sub cmdImportText_Click(
Dim dbs As DAO.Databas
Dim rst As DAO.Recordse
Dim strLine As Strin
Dim varArray As Varian
Dim myTextFile As Strin
' Replace the character in the next step with the actual delimiter that is used in the text fil
Const strDelimiter As String = "~
Set dbs = CurrentDb(
Set rst = dbs.OpenRecordset("tblImportData", dbOpenDynaset, dbAppendOnly
Open "C:\Data\Student Results.txt" For Input As #
Do While EOF(1) = Fals
' read one line (record) from text fil
Input #1, strLin
' split the line into an arra
varArray = Split(strLine, strDelimiter
rst.AddNe
' write the values into fields in the recordset using the desired array element
rst.Fields(0).Value = varArray(0
rst.Fields(1).Value = varArray(1
rst.Fields(2).Value = varArray(2
rst.Fields(3).Value = varArray(3
' etc. for all desired field
rst.Updat
Loo
rst.Clos
Set rst = Nothin
dbs.Clos
Set dbs = Nothin
Close #

End Su

 

[Ken Snell]

From my answer in another post:
-------------------------------------
Found the problem...and it's my error!

Change
Input #1, strLine

to
Line Input #1, strLine


Input will read to a "comma" delimiter. Line Input will read the entire
line.

That should fix the code for you!

--
Ken Snell
<MS ACCESS MVP>

Below is the code. Since I was first just trying it out to see how it

worked, I didn't include all of the fields. I'm emailing you the sample
data.

 

[rachael]

That seems to have done the trick! The fields are importing nicely and no more comma problems. Thanks so much for your help

rachael

----- Ken Snell wrote: ----

Found the problem...and it's my error

Chang
Input #1, strLin

t
Line Input #1, strLin


Input will read to a "comma" delimiter. Line Input will read the entir
line

That should fix the code for you

--
Ken Snel
<MS ACCESS MVP

Thanks for taking a look at this. Below are 5 records of data (identifyin information has been changed)
Student~PrsID~MAILID~InterID~Country~CareerL~CrsS5~CrsC5~SesC5~SesD5~EnrD5~
omD5~CanD5~CrsS6~CrsC6~SesC6~SesD6~EnrD6~ComD6~CanD6~CrsS7~CrsC7~SesC7~SesD
~EnrD7~ComD7~CanD7~CrsS8~CrsC8~SesC8~SesD8~EnrD8~ComD8~CanD8~CrsS9~CrsC9~Se
C9~SesD9~EnrD9~ComD9~CanD9~CrsS10~CrsC10~SesC10~SesD10~EnrD10~ComD10~CanD10
CrsS11~CrsC11~SesC11~SesD11~EnrD11~ComD11~CanD11~A1~A12741~A12742~A12743~A1
910~A12911~A12912~A12913~A12914~A12915~A12916~A12924~A12925~A12926~A12927~A
2928~A12929~A12930~A12938~A12939~A12940~A12941~A12942~A2~A3~A38~A38472~A384
3~A38474~A38520~A38521~A38522~A38596~A38600~A38629~A38671~A38672~A38673~A38
09~A38710~A38714~A38731~A38762~A38777~A38778~A38887~A38892~A38928~A38945~A3
946~A38947~A38966~A38967~A39~A39072~A39082~A39083~A39095~A39100~A39101~A391
2~A39127~A39145~A39213~A39241~A39283~A39336~A39337~A39338~A39347~A39402~A39
03~A39412~A39419~A39429~A39430~A39431~A39438~A39446~A39482~A39485~A39501~A3
502~A39529~A39530~A39531~A39562~A39564~A39716~A39769~A39770~A39771~A39785~A
9873~A39874~A39890~A39923~A39943~A39948~A39949~A39950~A39974~A39975~A4~A40~
40007~A40008~A40064~A40122~A40196~A40197~A40198~A40221~A40289~A41~A42~A43~A
4~A45~A4501~A4502~A4503~A4504~A4505~A4506~A4507~A4508~A4509~A4510~A4511~A45
2~A4513~A4514~A4515~A4516~A4517~A4518~A4519~A4520~A4521~A4522~A4523~A4524~A
525~A4526~A4527~A4528~A4529~A4530~A4531~A4532~A4533~A4534~A4535~A4536~A4537
A4538~A4539~A4540~A4541~A4542~A4543~A4544~A4545~A4546~A4547~A4548~A4549~A45
0~A4551~A4552~A4553~A4554~A4555~A4556~A4557~A4558~A4559~A4560~A46~A47~A4716
A4717~A4763~A48~A4803~A4805~A4846~A4861~A49~A4908~A4963~A5~A50~A5045~A5048~
51~A5101~A5154~A5195~A52~A5244~A5291~A53~A5344~A5345~A5374~A54~A543~A5435~A
44~A545~A546~A547~A548~A549~A55~A550~A551~A552~A553~A554~A555~A556~A557~A55
~A559~A56~A560~A561~A562~A563~A564~A565~A566~A567~A568~A569~A57~A570~A571~A
72~A573~A574~A575~A576~A577~A578~A579~A58~A580~A581~A582~A583~A584~A585~A58
~A587~A588~A589~A59~A590~A591~A592~A593~A594~A595~A596~A597~A598~A599~A6~A6
~A600~A601~A602~A603~A604~A605~A606~A607~A608~A609~A61~A610~A611~A612~A613~
614~A615~A616~A617~A618~A619~A620~A621~A622~A623~A624~A625~A626~A627~A628~A
29~A630~A631~A632~A633~A634~A635~A636~A637~A638~A639~A640~A641~A642~A643~A6
4~A645~A646~A647~A648~A649~A650~A651~A65
Hope, Bob~100037305 [email protected]~100080~Belgium~Consultan

~Completed ~TZ325 ~03-166
~08/18/2003~05/27/2003~08/22/2003~~Enrolled ~63069
~~~07/11/2003~~~Completed ~X00055
~~~04/28/2003~05/16/2003~~Enrolled ~SFPROJ01
~~~01/02/2004~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~5~~~
~~~~4~~~~~~~~~~~~~~~~~~~~~4~~~~~~~~~~~~~~~~~4~~~~~~~5~~~~~~~~~~~~~~~~~~~5~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~3~3~3~5~3~4~4~4~5~5~5~4~4~
~4~4~4~4~5~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~5~5~5~5~5~5~5~4~4~~4~4~4~4~4~3~1~5~5~~~~~~~~~~~~~~~~~~~~~~~~~2~2
3~1~1~1~1~3~1~2~2~1~1~2~1~1~3~1~4~2~1~1~2~1~4~4~1~~~~~

Kangaroo, Captain~000171370 [email protected]~10080~Unite

States~Consultant ~Completed ~TZ32
~03-2341 ~11/17/2003~09/05/2003~11/21/2003~~Completed
~630699 ~~~06/09/2003~06/12/2003~~Completed ~X000551
~~~04/28/2003~09/02/2003~~Completed ~SFPROJ01E
~~~04/07/2003~06/12/2003~~~~~~~~~~~~~~~~~~~~~~~~5~~3~5~5~5~5~5~5~5~5~5~5~5~5
~5~5~5~5~5~5~5~~~~5~~~~~~~5~~~~~~~5~~4~~~5~~5~~~~~~~~5~5~5~~~~~3~4~~5~~~~~~~
5~5~~~~5~5~~~~~~~~~~5~~~~5~~~~5~5~~~~~~~~~4~5~~~~~5~5~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~2~4~4~~~4~~~~~4~4~5~5~~4~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~1~2~3~1~1~2~1~2~1~2~~1~1~2~2~1~1~3~1~1~1~~2~1~1~2~1~4~1~3~4~5~
~4~~~~~~~~~~~~~~~~5~1~5~4~~~~~~~~~~~~~~~~~~~~~~~~~1~2~3~1~1~2~1~3~2~1~1~1~2~
2~1~2~4~3~1~2~2~1~2~1~1~3~1~5~4~4~4~3~5

Jojo, Joey~000173370 [email protected]~10140~United

States~Consultant ~Completed ~TZ325 ~03-1656
~06/09/2003~02/19/2003~06/13/2003~~~~~~~~~Enrolled ~X000551
~~~04/28/2003~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~4~3~4~3~3
~4~4~4~4~~5~4~5~4~5~4~5~3~4~2~~~3~2~4~2~4~4~2~3~3~3~~4~3~4~3~4~4~4~4~2~2~1~2
~3~1~1~2~1~3~2~2~1~1~1~2~2~2~3~4~4~1~2~1~2~1~4~4~3~~~~~~

Tufnel, Nigel~100039625 [email protected]~101440~United

Kingdom~Consultant ~Completed ~TZ325
~03-1959 ~10/06/2003~09/13/2003~10/10/2003~~Enrolled
~630699 ~~~10/01/2003~~~Enrolled ~X000551
~~~04/28/2003~~~Enrolled ~SFPROJ01E
~~~10/01/2003~~~Enrolled ~MSF201825
~~~10/02/2003~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~5~4~4~5~4~~~~~~~~4~4~~~~~~~~
~~~~~~4~~~4~4~4~~~~~~~~~~~4~~~~5~4~~~~~~~~4~4~4~~~~~~~~~~4~~5~~~~4~4~4~~~~~~
4~~~~~4~~~~~~~4~~~~~~~~~~~~~4~4~4~4~4~4~4~4~4~4~4~4~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~4~2~5~3~~~~~~~~~~~~~~~~~~~~~~~~~4~2~3~1~1~2~1~3
~1~1~1~2~1~2~1~2~3~1~1~2~2~1~3~1~1~3~1~~~~~~

Bird, Big~000170038 [email protected]~10150~United States~Consultant

~Completed ~TZ325 ~04-0025
~02/09/2004~01/16/2004~02/13/2004~~Completed ~630699
~~~02/02/2004~02/05/2004~~Completed ~X000551
~~~04/28/2003~07/12/2003~~Completed ~SFPROJ01E
~~~12/08/2003~12/08/2003~~Completed ~MSF201825
~~~02/02/2004~02/03/2004~~Completed ~MSF201849
~~~02/02/2004~02/03/2004~~Completed ~MSF201850
~~~02/03/2004~02/03/2004~~~~4~3~5~5~5~5~5~5~5~4~4~4~4~4~4~4~4~4~4~4~4~~~~4~~
~~~~~5~~~~~~~~4~4~~~4~~4~~~~~~~~4~5~5~~~~~3~4~~4~~~~~~~4~4~~~~5~5~~~~~~~~~~4
~~~~4~~~~4~5~~~~~~~~~4~5~~~~~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~4~4~~4~~4~~~~~~4~4~4~~4~4~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~3~2~3~2
~2~2~4~3~2~1~~1~1~2~2~2~2~1~3~2~1~~2~1~1~1~1~4~4~2~1~5~~5~~~~~~~~~~~~~~~~4~1
~5~2~~~~~~~~~~~~~~~~~~~~~~~~~4~2~3~1~1~2~1~3~2~2~1~1~2~1~2~1~3~3~1~2~2~1~2~1
~4~3~1~~~~~~

 

[Ken Snell]

You're welcome.

--
Ken Snell
<MS ACCESS MVP>

That seems to have done the trick! The fields are importing nicely and no

more comma problems. Thanks so much for your help!