text file importing

  • Thread starter Thread starter Bill H.
  • Start date Start date
B

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.
 
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.
 
Back
Top