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.
Member for
18 years 9 months
Member for18 years9 months
Submitted by Jonathan Ward on Thu, 2007-03-29 05:01
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?
Member for
20 years 3 months
Member for20 years3 months
Submitted by Hannes de Bruyne on Wed, 2007-03-28 04:06
Member for
10 yearsDear all, I have problem in
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
Member for
20 years 6 monthsRE: Import/Export
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.
Member for
18 years 9 monthsRE: Import/Export
that is great, thank you all very much for your help
Member for
22 years 11 monthsRE: Import/Export
Why not use the wk* format ?
Member for
19 yearsRE: Import/Export
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
Member for
18 years 9 monthsRE: Import/Export
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?
Member for
20 years 3 monthsRE: Import/Export
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