Importing Numbers

  • Thread starter Thread starter Hendrix10
  • Start date Start date
H

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?
 
Rather than allowing the TransferSpreadsheet to create the table, create your
own table to import into and define that field as a text field.
 
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.
Click to expand...


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
 
Back
Top