aeolianje
asked on
Problem importing from Excel to memo field in Access
I am trying to import an Excel spreadsheet into Access. There are > 255 characters in a few of the Excel cells - and so I have set up the Access field as Memo.
However, when I use the following VB code to import the spreadsheet, the data is getting truncated. What am I missing?
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tbl_MASTER_temp", GetFile2, True
Thanks for your help,
je
However, when I use the following VB code to import the spreadsheet, the data is getting truncated. What am I missing?
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "tbl_MASTER_temp", GetFile2, True
Thanks for your help,
je
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
double check your import specification
ASKER
Perfect! The original import was setting the format of the fields to "@". Once I removed that, it worked!
Thank you!
je
Thank you!
je
@aeolianje
Your closing comment suggests that the problem existed in the import specification. However, the accepted solution comment does not seem to refer to the import specification. Did you mean to accept that comment?
Your closing comment suggests that the problem existed in the import specification. However, the accepted solution comment does not seem to refer to the import specification. Did you mean to accept that comment?
aeolianje,
Glad to help.
akimark,
The TransferSpreadsheet method does not use import/export specifications:
http://msdn.microsoft.com/en-us/library/office/bb214134(v=office.12).aspx
Glad to help.
akimark,
The TransferSpreadsheet method does not use import/export specifications:
http://msdn.microsoft.com/en-us/library/office/bb214134(v=office.12).aspx
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "Newtbl_MASTER_temp", GetFile2, True