You can also copy and paste directly into a Table in ACCESS as long as
you have the same amount of columns in ACCESS as you have copied from
EXCEL. Sometimes it is easiest if all the fields in ACCESS are text
then it will accept the data a little more easier. If it doesn't accept
all of the data ACCESS will generate another table with the information
it wasn't able to import.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=497149