Import http url - ends up in errors table

  • Thread starter Thread starter Internet User
  • Start date Start date
I

Internet User

When I attempt to import a text file that includes a field that contains
urls, that field ends up in the errors table instead of the table I'm
importing into.

Seems to happen whether the field is set to text or the http. I suspect it
is due to length of the data. Are urls limited to 256 char like text? Is
there a work around?

Thanks in advance.
 
The Access hyperlink field type is based on the memo field and isn't
limited to 255 characters.

Have you tried creating the table first, with the appropriate field
types, and then importing the file into that table?
 
Oops. Didn't set the field to url datatype. All is good.
Thanks!
 
You must log in or register to reply here.

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

Similar Threads

Importing Text Files Into Access 1
Import errors importing Text into existing table, header vs no hea 3
CSV import error only with code 1
Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
import ignores the text format in table's field 1
Type Conversion Failure importing number as text 1
import dbf tables 2
Import errors from Excel 3

Back
Top