Excel Autonumber from Access


I have multiple files in Excel format. They are invoices that need a  a unique sequential number populated in a cell.

Is there a way to use MS access to generate this number with like a primary key, populate the cell, and record the filename in an access table??

Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
test this

* place the db together with the excel files in the same folder
* open the db and click get Excel files
* open table tblInvoices to check if the excel files were loaded

* close table and click Process Excel files
Rey Obrero (Capricorn1)Commented:
Yes, this is doable by using VBA codes.
TheDetectiveAuthor Commented:
Great, can you share the code?
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Rey Obrero (Capricorn1)Commented:
yes, but you need to give more detailed info...

a sample db and a sample excel file will help.
TheDetectiveAuthor Commented:
ok here are 4 spreadsheets with dummy invoices and and Access DB with a table.  Look at Cell B5  in the spreadsheet

My invoice schema is XXX-1, XXX-2, XXX-3, and so on.  I want to pull the number from access.

I want to use access to maintain the primary key and also to record the Invoice title for reference.

I can do some code, but I don't know the best way to interface between the two programs

Thanks for your help
TheDetectiveAuthor Commented:
not sure if the attachment made it
TheDetectiveAuthor Commented:
This is great.  Works like a charm.  Thanks so much!!!!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.