This may be asking alot, but it's what I'm trying to do, and I need help. I'm creating a customer survey database.
What I want access to do:
There will be a .xls with contact information and two columns will either have "Yes" or "No" in each. When the .db is opened, I want access to import only the rows with "No" and "Yes" respectively into the CustomersRecords table. However, this .xls name will have a name changing. Kinda like it'll be "crxls00023.xls" then next time it is updated it'll be "crxls00024.xls" and so on.
Any ideas?
What I want access to do:
There will be a .xls with contact information and two columns will either have "Yes" or "No" in each. When the .db is opened, I want access to import only the rows with "No" and "Yes" respectively into the CustomersRecords table. However, this .xls name will have a name changing. Kinda like it'll be "crxls00023.xls" then next time it is updated it'll be "crxls00024.xls" and so on.
Any ideas?