Importing Numbers

[Hendrix10]

I am importing an excell spreadsheet into access. One of the fields
that I'm importing has leading zero (ie 001-99-0099) which is saved as
an a special field so the leading 0's stay. When I import it into
access it changes it into a number field and removes the leading
zeros. How can I import the field and keep the zeros?

 

[Klatuu]

Rather than allowing the TransferSpreadsheet to create the table, create your
own table to import into and define that field as a text field.

 

[Ron2006]

What I have done is to open the spreadsheet from Access using

automation and then go to the appropriate tab, cell A2 and then insert
a row, I then place a 0 or X or a date into each cell across the
spreadsheet depending on what the data is supposed to be.
Then I close the spreadsheet,
Perform the transferspreadsheet
and then run a query that deletes the bogus record from the imported
table.

In this case you want to put an X in the column with the SSN
definition. This is because you want to have Access treat the field as
alphabetic not numeric.

Ron