Hi - I set up a transferspreadsheet Macro that imports an excel spreadsheet to a table I created in access called "Timesheet."
I keep getting import errors and it is because some of the fields in the excel spreadsheet are null. Is there any way to allow these null values to get imported?
I tried to set the "Allow Zero length" property in my Timesheet table to Yes but this still didn't work( there is no allow null option because I am using an older version of access). I also tried to set the "Required" property to no but this didn't work either.
If anyone has any ideas please let me know!
I keep getting import errors and it is because some of the fields in the excel spreadsheet are null. Is there any way to allow these null values to get imported?
I tried to set the "Allow Zero length" property in my Timesheet table to Yes but this still didn't work( there is no allow null option because I am using an older version of access). I also tried to set the "Required" property to no but this didn't work either.
If anyone has any ideas please let me know!