text file importing

[Bill H.]

Trying to import a text file where one of the "fields" has a narrative
component, like a memo field.

When I import it, that field gets truncated. How do I get it all in there?

Thx.

 

[Bill H.]

OK, found an easy answer with the import wizard. Change Field2 to Memo.

However, that caused another problem. :-(

The data to import is in a flat file, so I wrote a little vba to switch it
around using an INSERT INTO sql statement. Now the problem is that when it
encounters a very long text field, the limits of a sql string get reached
and thus I get an invalid syntax.

How do I get around that?

Thx.