transferspreadsheet import text truncate 255 inconsistancies

  • Thread starter Thread starter bill
  • Start date Start date
B

bill

I'm trying to import excel spreadsheets with text columns that exceed
255 and I'm having trouble getting it to work consistently. I have
tried importing into to a local and a linked database table where the
columns in question are defined as memo fields. The columns are
[table comment] and [Column comment]. I'm using excel and access
2003 and my code and ddl is as follows:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel11, _
"CSV Column Names_t", imfile_name, True

the table ddl is as follows:

. CSV Column Names_t, Table Name, VARCHAR, 100
. CSV Column Names_t, Table Comment, LONGCHAR, 1073741823
. CSV Column Names_t, Column Name, VARCHAR, 100
. CSV Column Names_t, Column Comment, LONGCHAR, 1073741823
. CSV Column Names_t, Column Transform Comment, VARCHAR, 255
. CSV Column Names_t, Column Datatype, VARCHAR, 255
. CSV Column Names_t, Column Null Option, VARCHAR, 255
. CSV Column Names_t, Column Average Width, VARCHAR, 255
. CSV Column Names_t, Column Is PK, VARCHAR, 255
. CSV Column Names_t, Column Is FK, VARCHAR, 255
. CSV Column Names_t, ERWin_Seq, COUNTER, 10

Any help would be much appreciated!
 
Try this:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
"CSV Column Names_t", imfile_name, True
 
Back
Top