I'm working on a table of user accounts for an application and want to be able to import a list of accounts and append them into the table. I have a macro that uses the TransferSpreadsheet function that works fine, but I want to read the accounts from the spreadsheet into a recordset first so I can do some error and duplicate checking first before adding them to the database. I have an Excel import template where the headers match the field names in the table. I'm just not sure how to open the file and read it into a recordset. I should be able to add the error checking myself. Also, the file will vary in length (could be 10 users, could be 100). Everything is 2007 version. Can anyone help me on this?
Let's just use the following and I'll adjust:
File to import: c:\import.xlsx
Fields: [Name]|[email]|[LoginID]