Importing Excel Spreadsheet to a table

[katz3yez]

I read some of the importing threads that are available but I didn't see one that matches my problem. I have 2 tables, submissions and claim groups. Since there will be hundreds of these spreadsheets with different claim group numbers, I would like to add a command button that will import an excel spreadsheet to the submissions table. The spreadsheet will have the same header as the submissions table. The command button will ask the user what claim group. Then whatever claim group it is, it will then import to the submissions table. I sound confusing, I know. Or I guess I'm the consfused one. Please help?

Thank you.

 

[Bat17]

A few questions
Are all the spreadsheets in the same folder?
is the claim group a unique identifer and the name of the spreadsheet?
is there a uniqe key in the spreadsheet to link it to the claim group table after import.

peter

 

[katz3yez]

The spreadsheets are not in the same folder but I can put them all in the same folder. I can rename the spreadsheet if it will make it easier. Yes, the spreadsheet will have the client group number which is the unique identifier.

Thank you.

 

[Bat17]

how will you be telling the db what file to import? browse for it?

Peter

 

[katz3yez]

I just got more clarification about these spreadsheets. Apparently, they will be coming from another database, exported into excel. From there, they can be named anything. Is browsing the easiest way?

Thank you.

 

[Bat17]

Easiest way for user would probably to put all of the spreadsheets that you want to import into one directory and have Access import everything from that directory and append it to your submissions table. not sure where your
claim groups table comes into it unless you just want the claim group number from the spreadsheet adding to it.

peter