Gustav Brock
Gustav at cactus.dk
Tue Nov 23 05:04:39 CST 2004
Hi John I don't think you can. An option might be to import the worksheet to a temp table. Then you can manipulate the data as you wish. If you find a method please let us know. /gustav >>> JColby at dispec.com 22-11-2004 19:23:39 >>> Does anyone know how to convert #Num! in a linked spreadsheet to a null or something useable in Access?