How to convert text-cells

D

Dietmar Brueckmann

Hi,

I've problems to import Excel-spreadsheet-data into our database. I'm using
Borland-Delphi-ADO, but a test with MS-Access importing feature leeds me
into the same problems.

The spreadsheet contains a col with only 9-digit values, but they have got
the text-attribut except of two that are numbers.
I see this when I delete the aligning-property, all cells are left
justified, but the two right.
I know I can give a col the text-attribute while importing data from a
textfile.
But I dont know how to delete the text-attribute or set it for a complete
col.

Best regards
Dietmar
 
I

IC

Dietmar Brueckmann said:
Hi,

I've problems to import Excel-spreadsheet-data into our database. I'm using
Borland-Delphi-ADO, but a test with MS-Access importing feature leeds me
into the same problems.

The spreadsheet contains a col with only 9-digit values, but they have got
the text-attribut except of two that are numbers.
I see this when I delete the aligning-property, all cells are left
justified, but the two right.
I know I can give a col the text-attribute while importing data from a
textfile.
But I dont know how to delete the text-attribute or set it for a complete
col.
Click to expand...

I don't know anything about importing Excel into databases but, to format an
entire column as text, click on the column header (to select the column)
then format cells as text. If this doesn't cure your problem, you could try
preceding the numbers with an apostrophe (eg '123). If you choose to format
as numbers, you will lose any leading zeros from your data (eg 0123 becomes
123).

Ian
 
D

Dietmar Brueckmann

IC said:
I don't know anything about importing Excel into databases but, to format an
entire column as text, click on the column header (to select the column)
then format cells as text. If this doesn't cure your problem, you could try
preceding the numbers with an apostrophe (eg '123). If you choose to
Click to expand...
format

Thanks for answering - but that doesn't help. The text-attribute is no
format-property.
I'm thinking it's only a feature of importing text-data-files.

My problem can be resolved in adding a new column and place a formula like
"=B2+0", "=B3+0" ... in the next free col if B is the col with wrong
values.
In that way you get a col with all numeric values and all is fine.
But that is a way with two many steps.
I'd hoped that somebody knows where the text-property is to set/delete for
selected row.
If you don't understand what I mean and you are interested in that problem I
could mail you an example .xls.
In importing it in Access you would see the wrong cells.

Best regards
Dietmar
 
D

Dave Peterson

Changing Text numbers to number numbers???

You may be able to just use Data|text to columns|finish

Or select an empty cell, copy it.
select your range
edit|paste special|check the Add button
 
Top