Could not import ascii data into a temporary .dbf table - Part 4. Error: Temporary table was not created. Please check that the file you are importing has fieldnames in the first row.
Definitely has column headings. Imports properly into Excel. Other manually built text files import properly.
Text file type? Has CRLF (x0D0A in file) UTF-8 no BOM, .... tried all the combos ....
=============================
Tried to upload versions of the file ... got an INVALID FILE from this forum site. File was not open elsewhere.
@#$%^& TEXT FILES!
Clues needed. Frustrated.
Carl
Dallas
=============================
Contents of "Invalid File" attached (trimmed to a few records.)
Cycle, Route, Account, Meter_Number, Read_Type_Code, Host_Sequence, Constant, Dials, Decimals, High_Audit, Low_Audit, Location, Instruction1, Instruction2, Account_Status, Address, Name, Survey_Flag, Previous_Estimates, Prev_Reading, Read_Date, Old_Seal, Special
02,000070,070-0003370-005 ,93131982 ,WM01,000000, ,04, ,0000000141,0000000108, , ,WT ,A ,"1201 HILLWOOD WAY ","BLAKE; DOMINIQUE/JOH",0,00,0000000000,1008,,
02,000070,070-0003580-004 ,10104232 ,WM01,000005, ,04, ,0000000051,0000000047, , ,WT ,A ,"1401 HAMPTON ROAD ","REDD; LAVARR M ",0,00,0000000000,1008,,
02,000070,070-0003590-008 ,32913409 ,WM01,000010, ,04, ,0000000956,0000000952, , ,WT ,A ,"1403 HAMPTON ROAD ","LASTER; PAT ",0,00,0000000000,1008,,
02,000075,075-0002650-003 ,10104214 ,WM01,002235, ,04, ,0000002057,0000001943, , ,WT ,A ,"202 E NORTHWEST HWY ","TULABER ",0,00,0000000000,1009,,"Los Amigos"
Definitely has column headings. Imports properly into Excel. Other manually built text files import properly.
Text file type? Has CRLF (x0D0A in file) UTF-8 no BOM, .... tried all the combos ....
=============================
Tried to upload versions of the file ... got an INVALID FILE from this forum site. File was not open elsewhere.
@#$%^& TEXT FILES!
Clues needed. Frustrated.
Carl
Dallas
=============================
Contents of "Invalid File" attached (trimmed to a few records.)
Cycle, Route, Account, Meter_Number, Read_Type_Code, Host_Sequence, Constant, Dials, Decimals, High_Audit, Low_Audit, Location, Instruction1, Instruction2, Account_Status, Address, Name, Survey_Flag, Previous_Estimates, Prev_Reading, Read_Date, Old_Seal, Special
02,000070,070-0003370-005 ,93131982 ,WM01,000000, ,04, ,0000000141,0000000108, , ,WT ,A ,"1201 HILLWOOD WAY ","BLAKE; DOMINIQUE/JOH",0,00,0000000000,1008,,
02,000070,070-0003580-004 ,10104232 ,WM01,000005, ,04, ,0000000051,0000000047, , ,WT ,A ,"1401 HAMPTON ROAD ","REDD; LAVARR M ",0,00,0000000000,1008,,
02,000070,070-0003590-008 ,32913409 ,WM01,000010, ,04, ,0000000956,0000000952, , ,WT ,A ,"1403 HAMPTON ROAD ","LASTER; PAT ",0,00,0000000000,1008,,
02,000075,075-0002650-003 ,10104214 ,WM01,002235, ,04, ,0000002057,0000001943, , ,WT ,A ,"202 E NORTHWEST HWY ","TULABER ",0,00,0000000000,1009,,"Los Amigos"
Comment