Solved

Can't seem to import all of the text in a cell

Posted on 2014-09-16
3
171 Views
Last Modified: 2014-09-17
I have the following code in a onclick event of a command button on a form.  But the problem I'm having is with a certain cell in the Excel file.  It has a lot of copy in it but the import function seems to be cutting it off after 255 characters.  Can someone help me?  I need to import all of the copy in that cell.  The field in the table the Excel file is being imported into is a memo field.

Here's the import code:

        Set fd = Application.FileDialog(msoFileDialogFilePicker)
        With fd
            .InitialFileName = Environ("userprofile") & "\Documents\"
            If .Show Then
            DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTempFieldNotesImport", .SelectedItems(1), False, "A1:B66"
            End If
        End With

Open in new window

0
Comment
Question by:SteveL13
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 12

Expert Comment

by:danishani
ID: 40325689
You need the change the Field Type to Memo, because Text field is limited to 255 characters.

Hope this helps,
Daniel
0
 

Author Comment

by:SteveL13
ID: 40325702
It is a memo field.
0
 
LVL 12

Accepted Solution

by:
danishani earned 500 total points
ID: 40325814
Sorry about that, this is known issue with Excel import to Access.

Truncated data

I think this link explains the solution very well, work with a temp table and than import to the final table where you want to have the records reside.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question