Problem with import

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I'm trying to import data from an .xls file. The first row contains the
headings that match the field names in the table. However I keep getting a
message to say there has been an error and the file has not been imported.
There is no indication what the error is though. The only thing I can see
that is wrong is that one column on the xls spreadsheet has a date in the
format dd/mm/yy which matches the format in the table, but when the file
spreadsheet appears in the import wizard the date appears as a 5 digit
number that doesn't look anything like a date. No matter what I do to the
format it doesn't change. Could that be the problem and if so how do I
change it?
Thanks
Tony
 
the date appears as a 5 digit number that doesn't look anything like a date.
Access and Excel stores dates and time as a decimal number but displays them
in several ways.
One problem when importing from Excel to Access is that Access tries to help
by change columns to what it thinks is correct.
If you have a column that has text and numerials the best way to import is
to add a new row under the headings and make sure there is text in those
cells.
 
Thanks Karl I'll have a look at that
Tony
KARL DEWEY said:
Access and Excel stores dates and time as a decimal number but displays
them
in several ways.
One problem when importing from Excel to Access is that Access tries to
help
by change columns to what it thinks is correct.
If you have a column that has text and numerials the best way to import is
to add a new row under the headings and make sure there is text in those
cells.
Click to expand...
 
Back
Top