[AccessD] Import more than 255 characters from Excel

Hale, Jim Jim.Hale at FleetPride.com
Tue Jul 18 14:00:05 CDT 2006


The fastest way is to link to the Excel sheet from within Access. The Excel
sheet will show up as a table. Then write a query to populate or create the
desired Access table. The query will recognize the Excel "field" as a memo
field. HTH 
Jim Hale

-----Original Message-----
From: ewaldt at gdls.com [mailto:ewaldt at gdls.com]
Sent: Tuesday, July 18, 2006 12:19 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Import more than 255 characters from Excel


I have a memo field in an Access table, and it receives data from an
imported Excel sheet. Unfortunately, the import cuts the length of the
imported data to 255, since Access automatically considers it a Text field.
Is there a way around this? I use the very simple line:

      DoCmd.TransferSpreadsheet acImport, 8, "Import01", strFileStuff,
False, "InputData"

I tried defining the table, "Import01", as filled with Memos; no
difference. Any help? I really need to import more than 255 characters. Is
there a setting in here somewhere? The spreadsheet is too complex to export
to a .CSV file, BTW. Also, "InputData" here is a named range.

TIA.


Thomas F. Ewald
FCS Database Manager
General Dynamics Land Systems
(586) 276-1256





This is an e-mail from General Dynamics Land Systems. It is for the intended
recipient only and may contain confidential and privileged information.  No
one else may read, print, store, copy, forward or act in reliance on it or
its attachments.  If you are not the intended recipient, please return this
message to the sender and delete the message and any attachments from your
computer. Your cooperation is appreciated.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.


More information about the AccessD mailing list