Hi Jim,
If you're importing the data from Excel into an existing table in Access with the field defined as text, I would think everything should import. However, defining the cell format as text in Excel does not guarantee the field will be typed as text in Access when you link to the Excel sheet. Access determines the data type by sampling the first few rows. If the data is all numeric, that column in the table will be typed as numeric. To ensure you get a text data type make sure the first row contains text in that column.
Another way to ensure you get the data type you desire is to save the Excel worksheet as a tab-delimited text file and use an import specification to import the data to Access.
Darrell
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Wednesday, February 20, 2013 2:00 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Excel to Access issue
Hello,
We are getting a download from a website and when you download it we save it as Excel 97-2003 and then try to import it into Access. But there are a combination of Vehicle #'s that are not all numbers but have numbers like P0729 and 0628. We have changed the format in excel to text for the column and changed the format of the table to text. But when we do the import, all vehicle numbers with the letters in the vehicle number are missing. Is there something that I am missing to get the characters to show in the access table?
Thank You
Jim Wagner
The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.
Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar