Solved

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

Posted on 2014-09-16
3
165 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
  • 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

770 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