×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • 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!
  • Students Click Here

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

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

MS ACCESS field was truncated after importing Microsoft Excel Comma Separated Values File (

MS ACCESS field was truncated after importing Microsoft Excel Comma Separated Values File (

MS ACCESS field was truncated after importing Microsoft Excel Comma Separated Values File (

(OP)
Dear Experts,

Being in a process of importing Microsoft Excel Comma Separated Values File (.csv)file into MS ACCESS 2010 table I face an obstacle because a certain field was truncated.
Then I have configured the table with field Memo type instead of text 255 barrier. However, try as I might, the field is still truncated.
Is there any simple way to overcome this problem?

Thank you in advance!
Estersita

RE: MS ACCESS field was truncated after importing Microsoft Excel Comma Separated Values File (

Hi,

First off, a .csv file is just a text file, regardless of its source.

Second, is there a COMMA in the data for the column you intend for your memo field?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: MS ACCESS field was truncated after importing Microsoft Excel Comma Separated Values File (

(OP)
SkipVought,

Thanks for the prompt response. I have just look at the file which is huge in Excel and used Find and select option to find comma if any. It was not found....

Estersita

RE: MS ACCESS field was truncated after importing Microsoft Excel Comma Separated Values File (

Did you open the .csv file directly with Excel or did you generate the .csv file using SaveAs?



Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: MS ACCESS field was truncated after importing Microsoft Excel Comma Separated Values File (

(OP)
I was sent .csv and tried to open it with Excel.
System message said, “.csv may contain features that are not compatible with csv(comma delimited). Do you want to keep the work book in this format?
-to keep this format which leaves out any incompatible features, click Yes
-To preserve the feature, click No. Then save a copy in the latest Excel format"


Initially I clicked NO, but actually was unable to find the "latest Excel format". Available Excel versions were earlier than mine Excel 2010 while I do have Access 2010. Should I had to?

Finally I clicked yes.....

RE: MS ACCESS field was truncated after importing Microsoft Excel Comma Separated Values File (

So you opened the .csv with Excel and then what did you do?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: MS ACCESS field was truncated after importing Microsoft Excel Comma Separated Values File (

(OP)
Then I imported the file from MS ACCESS 2010. It was not imported successfully. About 35,000 records were truncated .

RE: MS ACCESS field was truncated after importing Microsoft Excel Comma Separated Values File (

I am confused. If the file is a .csv and you have it opened in Excel, how could the nuxt thing that you did be “I imported the file from MS Access...”

???

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: MS ACCESS field was truncated after importing Microsoft Excel Comma Separated Values File (

(OP)
Sorry, I meant being in Access I imported source file into a table in the current database.

Now I tried another option. I link the data source by creating a linked table. There were no error anymore . Now the table looks OK. In this case I am not sure, howeve,r if I would be able to manipulate data properly as I never handled with linked table..Will I?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close