B
Ben
I'm importing data from an Excel spreadsheet in to Access using ADO.
Everything appears to work apart from when a cell in Excel contains a
comma-separated list (e.g. 1,3,5,6,7). If the cell only contains one number
the value is imported but if the cell contains a list then the ADO recordset
value is Null (as determined by a MsgBox). The Excel spreadsheet data
format for the cell is set to General.
Any suggestions?
Ben
Everything appears to work apart from when a cell in Excel contains a
comma-separated list (e.g. 1,3,5,6,7). If the cell only contains one number
the value is imported but if the cell contains a list then the ADO recordset
value is Null (as determined by a MsgBox). The Excel spreadsheet data
format for the cell is set to General.
Any suggestions?
Ben