Connecting Tech Pros Worldwide Help | Site Map

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

  #1  
Old April 16th, 2006, 03:45 AM
amy
Guest
 
Posts: n/a
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import different excel-files in one access-table MD answers 11 March 28th, 2007 03:55 AM
Modifying imported tables tfoale answers 7 February 12th, 2007 01:06 AM
many excel files import to One Table in Access amy answers 2 April 16th, 2006 03:35 PM
Help with SQL Update Query -- Not sure how to approach this situation Alex answers 2 July 20th, 2005 02:16 AM