rdracer58
asked on
Access - Excel Data Import
I am trying to import an Excel spreadsheet into an Access 2010 database. There are several columns in the spreadsheet where the cell values are marked with "X" if a value of "Yes" was intended or left blank if a value of "No" was intended.
Is it possible to import these columns and have the "X" automatically converted to 'yes" and blanks converted to "no"? If so, how do I go about doing this?
Is it possible to import these columns and have the "X" automatically converted to 'yes" and blanks converted to "no"? If so, how do I go about doing this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Would it then be possible to link it to a new spreadsheet? The potential issue is that we have a need to consistently update the data through new spreadsheets.
Yes,
I normally use the TransferSpreadsheet method to link Excel spreadsheets to Access, then use Access queries to transform the data (as necessary) to get it into the format I want it in in Access. I the next time I link that table from another spreadsheet, I don't have to worry about it.
I normally use the TransferSpreadsheet method to link Excel spreadsheets to Access, then use Access queries to transform the data (as necessary) to get it into the format I want it in in Access. I the next time I link that table from another spreadsheet, I don't have to worry about it.
IIF([SomeField] = "X", "Yes", "No")