One more question... not quite as idiotic

L

LonghornBob

I've gotten the numerical problem handled, and now I have a differen
hitch in the getalong.

I have a table in Access and I need to get all the info from the Exce
spreadsheet into this table. It won't let me cut and paste the whol
thing, maybe because I don't have the same number of rows.

I can't seem to get Excel to create new rows for me unless I add the
one at a time (and I'm not doing that 2500 times), and I'm not sure ho
in the world to get this data over there.

Arrgghhh...

Any ideas?

Thanks in advance,

Wheele
 
N

newtechie

Bob,

Going off the top of my head, I'm sure you can import and link tables
between Access and Excel. Under Help in Access, type in a search for "Get
External Data".

Hope this helps,
Newtechie
 
L

LonghornBob

It doesn't seem to want to let me do that.

Thanks for the effort though.

I'm thinking I'm going to go to the Access board with this one becaus
it seems to be more Access specific now that I think of it.

Gracias,

Wheele
 
Top