Re: Copy and Paste from Excel problem



On Mar 30, 5:18 am, "andrewmac" <a.d.macken...@xxxxxxxxx> wrote:
On Mar 29, 3:27 pm, "DavidB" <j...@xxxxxxxxx> wrote:





What error message are you getting? Looks like there is somethign
wrong with the 4th record. Normally its either an invalid data type
or a duplicate in a uniqur index field.

On Mar 29, 6:29 am, "andrewmac" <a.d.macken...@xxxxxxxxx> wrote:

I hope someone can help - I am new to Access so please be patient.

I have a list of about 100 equity tickers in a column in Excel
formatted as Text. I am trying to copy and paste into a field in a
table in Access with Text data type. For some reason Access only
wants to paster the first 3 records.

Can anyone please help me?

Thanks in Advance

Andrew.

I'm not getting any error message. It just pastes the first three
records. Most odd.- Hide quoted text -

- Show quoted text -


Have you tried using Import?

.



Relevant Pages

  • Re: Copy and Paste from Excel problem
    ... Normally its either an invalid data type ... or a duplicate in a uniqur index field. ... For some reason Access only ...
    (comp.databases.ms-access)
  • Re: Copy and Paste from Excel problem
    ... Normally its either an invalid data type ... or a duplicate in a uniqur index field. ... For some reason Access only ...
    (comp.databases.ms-access)