View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
external usenet poster
 
Posts: 400
Default removing commas in csv

As far as know, it is not possible to import into MEMO (or more
appropriately IMAGE) columns (which contain Byte arrays) in Access using SQL
(what Import will be using). I have used ADO and its AppendChunk method to
retrieve Byte() arrays and then the Update method to write to the table.