Importing large cell from Excel tewald 18.07.2006 13:04:02 I'm trying to import from Excel via VBA; sure, that's easy with DoCMD.ImportSpreadsheet. Unfortunately, it has the same limitation as using the Import Wizard: Excel automatically identifies data types, and any alpha content causes the data to be imported as a Text field. This limits the data to 255 characters, and I need more than that. I can format the receiving field to be Memo, but I can't change the import itself. How would that be done? TIA, -- Thomas F. Ewald tewald[ at ]yahoo.com

RE: Importing large cell from Excel Klatuu 18.07.2006 15:02:02 Import to an existing table with the field types and sizes already defined. "tewald" wrote: [Quoted Text] > I'm trying to import from Excel via VBA; sure, that's easy with > DoCMD.ImportSpreadsheet. Unfortunately, it has the same limitation as using > the Import Wizard: Excel automatically identifies data types, and any alpha > content causes the data to be imported as a Text field. This limits the data > to 255 characters, and I need more than that. I can format the receiving > field to be Memo, but I can't change the import itself. How would that be > done? > > TIA, > -- > Thomas F. Ewald > tewald[ at ]yahoo.com >

RE: Importing large cell from Excel tewald 18.07.2006 15:06:02 I already tried that and it did not work. It's just a single field of Memo size, but it still receive donly 255 characters. -- Thomas F. Ewald "Klatuu" wrote: [Quoted Text] > Import to an existing table with the field types and sizes already defined. > > "tewald" wrote: > > > I'm trying to import from Excel via VBA; sure, that's easy with > > DoCMD.ImportSpreadsheet. Unfortunately, it has the same limitation as using > > the Import Wizard: Excel automatically identifies data types, and any alpha > > content causes the data to be imported as a Text field. This limits the data > > to 255 characters, and I need more than that. I can format the receiving > > field to be Memo, but I can't change the import itself. How would that be > > done? > > > > TIA, > > -- > > Thomas F. Ewald > > tewald[ at ]yahoo.com > >