Hi Graham,
Well after careful observation I have noticed that there were % characters throughout the text file. So I tried a little trial and error and changed the % to a . (period).
So after re importing the file, It brought over everything except for a couple of key pieces of data.
This is the message that Access tell me.
Finished Importing File 'C:\Documents and Settings\mark\desktop\assignment1.txt'to table 'Assignment1'. Not all of your data was successfully imported. Error description with associated row numbers of bad records can be found in the Microsoft Access table "assignment1_ImportErrors2'.
Thanks for your help so far, as I do appreciate it.
Mark
__._,_.___
.
__,_._,___
Tidak ada komentar:
Posting Komentar