If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
copy for EXCEL and paste into ACCESS
Hi, I am an ACCESS newbie and have a very simple question.
I am trying to copy one column in EXCEL and paste it into an ACCESS table, which has only one column but already has some existing data. The ACCESS table expects "text". After I select the cells in the single EXCEL column and copy the contents and then select the first available cell in the ACCESS table and hit "paste", it complains "the text is too long". It appears that the copy/paste process concatenates the contents of the EXCEL cells and makes it one long text and tries to put this concatenated long text into one cell in ACCESS. Any idea on how to solve this? Thanks. Richard |
#2
|
|||
|
|||
copy for EXCEL and paste into ACCESS
You probably were clicking in the field of the Access record.
Try highlighting the cells to copy (not highlight the column), copy, select the field and records (cells and rows) in Access, highlighting as many field-records as was copied, and paste. -- Build a little, test a little. "Richard" wrote: Hi, I am an ACCESS newbie and have a very simple question. I am trying to copy one column in EXCEL and paste it into an ACCESS table, which has only one column but already has some existing data. The ACCESS table expects "text". After I select the cells in the single EXCEL column and copy the contents and then select the first available cell in the ACCESS table and hit "paste", it complains "the text is too long". It appears that the copy/paste process concatenates the contents of the EXCEL cells and makes it one long text and tries to put this concatenated long text into one cell in ACCESS. Any idea on how to solve this? Thanks. Richard |
#3
|
|||
|
|||
copy for EXCEL and paste into ACCESS
Richard wrote:
Hi, I am an ACCESS newbie and have a very simple question. I am trying to copy one column in EXCEL and paste it into an ACCESS table, which has only one column but already has some existing data. The ACCESS table expects "text". After I select the cells in the single EXCEL column and copy the contents and then select the first available cell in the ACCESS table and hit "paste", it complains "the text is too long". It appears that the copy/paste process concatenates the contents of the EXCEL cells and makes it one long text and tries to put this concatenated long text into one cell in ACCESS. Any idea on how to solve this? Thanks. Richard A more reliable method may be to copy and paste as necessary within Excel in order to get an Excel file which contains only the data you want to copy to Access. Then (having backed up your Access file - see Help) use the Import option (see Help), appending to the table desired. Access is very picky (rightly) about wanting the data in the right format (this is less of a problem with text). Phil, London |
Thread Tools | |
Display Modes | |
|
|