One more question... not quite as idiotic

  • Thread starter Thread starter LonghornBob
  • Start date Start date
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
 
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
 
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
 
Back
Top