copy and paste from excel

[buggirl]

OK, so I know it's wrong to simply paste from Excel to Access. But I don't
really understand why - can anyone explain to me what the difference is
between importing and pasting [and keep it simple - I'm a biologist, not a
computer geek ]

I have pasted some data from Excel to Access and then found that the data
doesn't show up in queries. I tried re-typing some of the new data directly
into Access and it still doesn't show up. I only re-typed the first few
columns (which contain input masks and drop-down lists) but didn't re-type
all of the other data (which is 'just' numbers).

Any suggestions? I don't want to re-type all that data - there's about 120
columns and 200 rows...

Oh, and I also tried exporting the data back into Excel and then importing
(rather than pasting) it back into Access, but that didn't work either.

Help!

 

[buggirl]

Ah ha! I discovered an issue with the relationship between my different
spreadsheets. I think that has solved the disappearing data mystery.

But I would still be happy if someone explained the difference between
pasting and importing...

 

[Jeanette Cunningham]

buggirl,
you can use copy and paste for an occasional transfer from excel to access
when you (the developer) know how the tables are set up and how to make sure
that the data integrity is not compromised.
If you want to use copy and paste often, it is safer ( from a data point of
view) to set up an import process which keeps the data safe.

Jeanette Cunningham

Ah ha! I discovered an issue with the relationship between my different
spreadsheets. I think that has solved the disappearing data mystery.

But I would still be happy if someone explained the difference between
pasting and importing...

OK, so I know it's wrong to simply paste from Excel to Access. But I
don't
really understand why - can anyone explain to me what the difference is
between importing and pasting [and keep it simple - I'm a biologist, not
a
computer geek ]

I have pasted some data from Excel to Access and then found that the data
doesn't show up in queries. I tried re-typing some of the new data
directly
into Access and it still doesn't show up. I only re-typed the first few
columns (which contain input masks and drop-down lists) but didn't
re-type
all of the other data (which is 'just' numbers).

Any suggestions? I don't want to re-type all that data - there's about
120
columns and 200 rows...

Oh, and I also tried exporting the data back into Excel and then
importing
(rather than pasting) it back into Access, but that didn't work either.

Help!