Entering 16 digit numbers into number field

[chrismid259]

Hi all,
I'm currently creating a database that must hold 16 digit credit card numbers. The numbers should be formatted so that there is a space after every four numbers (eg. 1234 1234 1234 1234). When I copy and paste the card numbers into Access from Excel, I end up with "2.1528492378042E+15".

Is there anyway around this?
Thanks in advance.

PS: This is for a college project, I'm not actually storing real card numbers.

[weekend00]

use Text field if you need spaces in the table data,
or Decimal if spaces only need in report.

[chrismid259]

use Text field if you need spaces in the table data,
or Decimal if spaces only need in report.

Thank you for your quick respone?

Seems to work when I copy one at a time. When I copy multiple cells it appears as 2.1528492378042E+15.

Is there a way of copying multiple cells from excel to access?

[weekend00]

if you have spaces in between every 4 digits in Excel, it must be all right when you paste to Access (text field). it can't be converted into a number automatically.

if you have 16 digit number in Excel...... I could not put 16 digits number in Excel, it cuts the number.

if you want to put 16 digits in Excel, you need to set cell format to text first then input digits. in this case, you can copy cells and paste to Access(text or decimal field).

[chrismid259]

I have set the cell formats to text then input the digits. I then copy the cells to access but it doesnt seem to be working.

[weekend00]

did you see 16 digits in Excel? did you paste to a text field?

[chrismid259]

did you see 16 digits in Excel? did you paste to a text field?

To test it, I copied the number 3155305189456750 from Excel to Access and it appears in the text field in Access as 3.15531E+15.

I did paste to a text field in Access.

[weekend00]

In Excel, you need to set the cell format to text, then paste the text in or type the text in. you should see 3155305189456750 instead of 3.15531E+15 in Excel.

if you see 3.15531E+15, you can never get back the sixteenth digit because in Excel, a number have at most 15 digits. any digit on the 16th will be set to 0. e.g. if you type in 3155305189456751, it will set to 3155305189456750.