Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 584
  • Last Modified:

Excel Autonumber from Access

Hello,


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??



Thanks,
Omar
0
TheDetective
Asked:
TheDetective
  • 4
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
Yes, this is doable by using VBA codes.
0
 
TheDetectiveAuthor Commented:
Great, can you share the code?
0
 
Rey Obrero (Capricorn1)Commented:
yes, but you need to give more detailed info...

a sample db and a sample excel file will help.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
0
 
TheDetectiveAuthor Commented:
not sure if the attachment made it
Invoices.zip
0
 
Rey Obrero (Capricorn1)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
Database18Rev.accdb
0
 
TheDetectiveAuthor Commented:
This is great.  Works like a charm.  Thanks so much!!!!!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now