Solved

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

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

832 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