automating the import of a xls file

[Jerome Ranch]

I collect information from people via an xls file...columns are fixed
(name and number), rows are variable. It has validation rules for
data entry in some fields.
Currenty I just import the xls into access, and then append the
records from the imported table into the main table.
I'd like to "automate" this process..I'd appeciate your brainstorming
sugestions.
One route I was just thinking of this AM is to have the data entry
directly into ACCESS. But then I'd have to build a data entry process
with signmificant error checking and I would not have the control over
what gets placed into the main table (since i am the gatekeeper).

Not many records get added..maybe 30 monthly.

Jerry

[Steve]

The syntax is:

DoCmd.TransferS preadsheet acImport, acExcelVersion, "tableName" ,
"FileName", HasFieldNames

So to import a spreadsheet with fieldnames from Excel XP, your
statement would look like:

DoCmd.TransferS preadsheet, acImport, acSpreadsheetTy peExcel9,
"tblName", "fileName", True

There's more information in Access help on the
DoCmd.TransferS preadsheet method.

[jerry.ranch]

Thanks for the info and lead Steve
I will see how this goes for me
Jerry
On 13 Jan 2006 06:08:13 -0800, "Steve" <th*********@gm ail.com> wrote:

The syntax is:

DoCmd.Transfer Spreadsheet acImport, acExcelVersion, "tableName" ,
"FileName", HasFieldNames

So to import a spreadsheet with fieldnames from Excel XP, your
statement would look like:

DoCmd.Transfer Spreadsheet, acImport, acSpreadsheetTy peExcel9,
"tblName", "fileName", True

There's more information in Access help on the
DoCmd.Transfer Spreadsheet method.

[Red]

If it doesn't work well for you, email me, and I will explain a
different way to do it.

`Red