access from excel

[Kevin Wood]

This is probably an easy one for you guys, whats the best
way of converting an excel wordsheet to an access file.
Theres a fair amount of data too much to do line by
line. I assumed even at worst case I could cut and paste
a few columns at a time but access tries to put the
entire clipboard into one cell. Is there any way around
this?

Thanks

Kevin.

 

[John Nurick]

Hi Kevin,

There are various possible complications depending just what's in the
worksheet but the first thing to try is importing the worksheet with
Access's File|Get External Data|Import... command.

This is probably an easy one for you guys, whats the best
way of converting an excel wordsheet to an access file.
Theres a fair amount of data too much to do line by
line. I assumed even at worst case I could cut and paste
a few columns at a time but access tries to put the
entire clipboard into one cell. Is there any way around
this?

Thanks

Kevin.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.