Adding excel files to a table in access Help please

[outhere]

Hi,
Simple question for most of you; however I'd sure could use the help!
I have customer info files (many) in excel (.xls or .csv) and would like to add these to a master database in Access97, to a table that already exists...
Just to complicate things a bit more, some of the feilds in these excel files arent all the same, meaning they dont really match or are not in the same order in the Access table. I remember once doing it, therefor I know its possible, I just cant recall how to do it. I remember dragging say the first name from one and dropping it on the feild where I wanted that Info to go...
Anyhow, hope I explained myself properly and thanks for all you advice!
Peace
Steve

 

[ETID]

After you get the colums in the correct order in excel,...
save the workbook.

Open the access database and right click in the "tables" object. then choose import,..when the file diaglog box opens, make sure you select files of type as msexcel or txt if your files are csv, then find the file you want to import.

the wizard should then ask you if you want to import to a new table or an existing one.

 

[outhere]

Thanks ETID,

Didn't think i'd be so easy...Ill try that later this evening.

So, if I'm reading between the lines correctly; there must be the same feilds, in the same order, on the excel files to the table that I'm importing into? Think thats what you meant...(makes sence)

Have a great Sunday Afternoon!!
Ps. Anyone catch any of those great CFL (Canadian Football League) playoff games today?
I personally cant wait 'till next Sunday; when the Grey Cup is held In Montreal...My Hometown! (Anyone lookin' for tickets or a place to stay next weekend; let me know!)

Cheers
Steve

 

[ETID]

Your fields should be in the same order and of the same type..I.E. date, number, text etc. unless you want to declare them on import with a field definition file (the wizard will explain) ...you can also update a table in access with an append query that you define.