Need to run a saved Import spec from VBA code.
Have been trying the DoCmd.TransferSpreadsheet but my Excel fields are Memo size. Transfer only brings the first 255 characters. The only way I've been able to get the entire fields passed in is to use a saved Import spec. How can I automate this in VBA. If I try the transgfer methods I've seen here, inspecting each cell for <>"" and importing within a loop, then I still get only 255 chars. I'm much more used to manipulating dynasets than calling these functions but it looks like a job for Dir level commands. Thanks.