text file importing


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.
 
Ad

Advertisements

B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top