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.TransferSpreadsheet acImport, acExcelVersion, "tableName",
"FileName", HasFieldNames

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

DoCmd.TransferSpreadsheet, acImport, acSpreadsheetTypeExcel9,
"tblName", "fileName", True

There's more information in Access help on the
DoCmd.TransferSpreadsheet 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*********@gmail.com> wrote:

The syntax is:

DoCmd.TransferSpreadsheet acImport, acExcelVersion, "tableName",
"FileName", HasFieldNames

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

DoCmd.TransferSpreadsheet, acImport, acSpreadsheetTypeExcel9,
"tblName", "fileName", True

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

[Red]

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

`Red