How can I import CSV with Carriage Return?

[needin4mation]

Hi, I have a set of comma delimited values in a text file. They import
fine. However, they are all in one record. How can I get each value
on one record? For example, say I have:

toys, books, shoes, houses

If I import, I get them all on one row.

I want each one on a separate row:

toys
books
shoes
houses

Any ideas?

Thanks for any help.

[Tom van Stiphout]

On 9 Mar 2006 19:38:38 -0800, ne***********@gmail.com wrote:

You would have to process this file using regular file i/o functions
such as Open, Line Input #, etc., and then add each word to the table
using an Append query or a recordset.AddNew.

-Tom.

Hi, I have a set of comma delimited values in a text file. They import
fine. However, they are all in one record. How can I get each value
on one record? For example, say I have:

toys, books, shoes, houses

If I import, I get them all on one row.

I want each one on a separate row:

toys
books
shoes
houses

Any ideas?

Thanks for any help.

[Terry Kreft]

You can use File I/O as Tom suggests or you can import to a table and then
open a recordset on the imported table and run through the fields apending
the values to your target table then drop the imported table.

e.g. Where the imported text file is in table MyText the target table is
MyTarget the Target field is MyTargField

Using DAO
dim db as DAO.Database
dim rsSce as DAO.Recordset
dim rsTarg as DAO.recordset
dim fldSce as DAO.Field

set db = Currentdb

set rsSce = db.Openrecordset(SELECT * FROM MyText)
set rsTarg = db.Openrecordset(SELECT * FROM MyTarget)

with rsSce
Do Until .EOF
for each fldSce in .Fields
rsTarg.AddNew
rsTarg.Fields(MyTargField) = fldSce.Value & ""
rsTarg.UpDate
Next
.MoveNext
Loop
.Close
End With

rsTarg.Close

Set rsSce = Nothing
Set rsTarg = Nothing
Set db = Nothing

--

Terry Kreft
<ne***********@gmail.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...

Hi, I have a set of comma delimited values in a text file. They import
fine. However, they are all in one record. How can I get each value
on one record? For example, say I have:

toys, books, shoes, houses

If I import, I get them all on one row.

I want each one on a separate row:

toys
books
shoes
houses

Any ideas?

Thanks for any help.