INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...On your site I feel quite confident that the contacts and feedback will make my life a little less hectic..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Project and Data Management > Data Management Programming Tools > Data Access solutions Forum

import csv file field > 255 characters

Read More Threads Like This One

jebushatescats (IS/IT--Management)

6 Jun 06 14:44

Hello all

I have an existing application that imports a csv file and loads it into a access DB. The users want to be able to include commas in the field values so I have decided to read in the file using ADO to split up the fields. I have this working except for one problem. It appears as if when I try to assign a field value fromm the csv file greater than 255 characters in length, ado drops the value and assigns a null value to the recordset field.

How can I import from a csv file using ado fields that are greater in length than 255 char's.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Data Access solutions