Connecting Tech Pros Worldwide Forums | Help | Site Map

import and combine all excel files to One Table in access.

amy
Guest
 
Posts: n/a
#1: Apr 16 '06
Hi, all:[color=blue]
> i am a new end user of access, now I have many excel files need to
> import to One table in access (combine all excel files into one table
> in excel). In excel files, some columns will have both # and text in
> the same column. The coloumn names in each excel file are mostly same
> but still a lot of different names(items). I was told to set up import
> specification, but how? i am not a programer or not access
> professional, please help me with direct information with simple
> language.[/color]


Closed Thread