Excel Template to Access DB?

[Bryan via AdminLife]

Is there any way to code an export of data on an individualclient from an excel worksheet to a database? I have aspreadsheet template that my company uses for individual clientsthat would be perfect to also add customer info into ourdatabase, but am running into major problems when trying toautomate the task on a case by case basis, as each templatedsheet is filled out. Any suggestions would be greatlyappreciated.

 

[Joe Fallon]

My advice would be to eliminate the Excel sheets altogether and build data
entry screens in Access so that everyone can enter the data "on line". Put
the mdb file on a network share (after splitting it into a Front End and
Back End) and then everyone will have access to it.

I typically import Excel spreadsheets, not link them. Others prefer linking.
You could code 12 Import routines of named ranges easily enough so you only
have to click a button to run them all.
Use transfer Spreadsheet for this.



--
Joe Fallon
Access MVP



Is there any way to code an export of data on an individual client from an
excel worksheet to a database? I have a spreadsheet template that my company
uses for individual clients that would be perfect to also add customer info
into our database, but am running into major problems when trying to
automate the task on a case by case basis, as each templated sheet is filled
out. Any suggestions would be greatly appreciated.