Rabu, 20 Februari 2013

[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

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar