Search results

Duh, I'm an idiot. LOL . . . Thanks. :cool:

I want to import only the information from an excel sheet like the one below where the answers for Q1 and Q2 are No and Yes respectively. I'm using this code below that is working but importing all cells: Private Sub Command31_Click() DoCmd.TransferSpreadsheet acImport, _...

I'm going to bump this for you because I'm looking for the same.

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.

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...

Thank You, got it to work that time.

I'm making a customer survey database. Also be aware I'm not proficient with access. All the customer information is being imported from an excel spreadsheet. That will include ServiceRecordID, ServiceDate, TechID, CustName, ServLocation, PhoneNum, and DeptID. Another table will include...

Thank you very much. Spaces are why I hate code :mad: I just got back from a meeting, and I'm gonna be changing things up. I'm sure I'll be asking for help alot in the next week

First off, I am not a programmer. I'm making a database for work basically because I am the only person who can attempt to understand access. I'm doing pretty good so far. I found some help with code examples off the web, but I've run into this problem. This code is supposed to create a report...