Beginner Help

[whoneeds8]

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?

 

[MarkK]

It's not that clear to me what you're trying to accomplish, but I'd avoid going back and forth from Access to Excel like that.

 

[whoneeds8]

Well, I'm not really going back and forth, I'm only importing an .xls to a table once automatically when the access file is opened.

 

[MarkK]

Do you have a series of different Excel files from which you need to extract data, or will the source file be the same one renamed?
Is it essential that the operation occur when the Access file is opened?

From the Access menu File->Get External Data->Link Tables you can very easily connect to an Excel file. Then you can write an append query that selects data from your linked Excel file and dumps it in an Access table.