Bhupinder: If you need finer control over the importing of data from Excel, use a little VBA. An intro article on this is at http://www.databaselessons.com/access-data-to-excel-1.php
although the article talks about sending data TO excel, it is easy to turn the code around in order to bring it FROM excel to Access. Richard "Manxman" Killey for more MS Access tips, visit http://www.databaselessons.com -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Bhupinder Sent: March 1, 2007 7:46 AM To: [email protected] Subject: [Access VBA Central] How to Import row number from Excelseet ???? Please help me. hi , i am working with MS Access 2000 and Excel. I need to keep track of row number of the record that i have imported from excel using "DoCmd.TransferSpreadsheet" As it does not import the rows as it is in the excel sheet. it imports all the records randomly. Apart from this could you pls tell me how can i add a autonumber column to an existing table programiticaly or by a query so that i can call it in my program. Please Help me. Thanx in advance. Bhupinder Singh [Non-text portions of this message have been removed]
