J
John Spencer
You can try the following if your table structure is always consistent.
-- Define an table structure - TheTableBlank - with all your fields and add
a sequential autonumber field as the primary key
-- Copy the table structure (Docmd.CopyObject
Currentdb().Name,"TheTable",acTable,"TheTableBlank")
-- APPEND your records to the table you have just created
THAT MAY give you the records in sequence. BUT remember TABLES are
unordered. If you want to impose an order you must sort the data either
using a query or in Access imposing a sort order on the datasheet view. If
you don't impose an order on the datasheet view of a table and there is a
primary key in the table, then Access will show the records in primary key
order (at least that is the behavior I have observed)
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
-- Define an table structure - TheTableBlank - with all your fields and add
a sequential autonumber field as the primary key
-- Copy the table structure (Docmd.CopyObject
Currentdb().Name,"TheTable",acTable,"TheTableBlank")
-- APPEND your records to the table you have just created
THAT MAY give you the records in sequence. BUT remember TABLES are
unordered. If you want to impose an order you must sort the data either
using a query or in Access imposing a sort order on the datasheet view. If
you don't impose an order on the datasheet view of a table and there is a
primary key in the table, then Access will show the records in primary key
order (at least that is the behavior I have observed)
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..