Import/Export
Forum Sponsor
Top Posters
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts
Dear all,
I have problem in importing xer p6 file.
Error occur "CVRCU-1939-9 Default value provided for field ev_compute_type is not valid"
Waiting for your inputs.
COCOY
2048 lines to be exact.
Oh and if youre importing as DBF file type, the field types take their values from the row below the headings. So if your first row contains blanks, adn the second row contains a date, then the DBF file will import that field as a text field and will not import the dates correctly.
that is great, thank you all very much for your help
Why not use the wk* format ?
Hi Jonathan,
1) Use Insert-> Name-> Define
2) then select "Database"
3) Erase the range on Refer to box
4) Hilight the range to you want for Database
5) Click Add and then Okay
That should change the range of your database.
Regards,
Rodel
thanks for your help, think i may still be missing something here, i have selected all of the new data that i have entered on the sheet, gone to Insert-Name-apply, then having selected database i get the error that reads Microsoft Excel cannot find any references to replace, the file will not retain any of the data that i have entered?
Hi
something I learned in this forum some time ago:
in the Excel menu look at Insert->Name. Here you wil find a range called "database". This range must be changed to the new range. Thats all.
Hannes