SQL read number> 15 digit in Excel

[bruindav]

How can I retrieve a number > 15 digits from a database into Excel using a SQL query. Excel will cut off numbers at 15 position. So a Creditcard nr (16 digits) will lose it lasts digit

 

[Jonmo1]

Welcome to the board..

In the database, store it as a TEXT instead of NUMBER.

 

[bruindav]

Thanks for the suggestion , but it is not possible to store it in de AS400 DB as text. I am not the owner of the database. I only have read permission. If you have any other suggestion you're welcome

Welcome to the board..

In the database, store it as a TEXT instead of NUMBER.

 

[Jonmo1]

Perhaps formatting the destination cells as TEXT, PRIOR TO retrieving from the database?

 

[bruindav]

That's and option I have to try. . Or maybe first store the result in a textvariable and than cut in two.

Perhaps formatting the destination cells as TEXT, PRIOR TO retrieving from the database?

 

[Richard Schollar]

If that doesn't work, I would try concatenating the telephone number field to a character to convert to text (do this in the SQL itself). You'd need to process it after import if you wanted to remove the character.

I'm not sure of the driver (ODBC or OLEDB) that you're using so the following may not work:

SELECT 'A' + [TelNoField] FROM Table

etc etc. If you can, I would go for a concatenation using the sigle quote ' character as it will hopefully be placed into the cells as a textual number requiring no further modification.