Copy data from Excel (Ctrl+C) text number

  • Thread starter Thread starter Boon
  • Start date Start date
B

Boon

Hello,

When I copy the data from Excel and paste in into the table in Access, some
weird things happen.

If the first row first column in excel is numeric, and the rest in the first
column is numeric, everything will come into Access when I copy.

But if the first row first column in excel is numeric, and the rest in the
first column is text, it will come into Access just one row.

Would you explain what is happening here?

Thanks,
B
 
Hello,

When I copy the data from Excel and paste in into the table in Access, some
weird things happen.

If the first row first column in excel is numeric, and the rest in the first
column is numeric, everything will come into Access when I copy.

But if the first row first column in excel is numeric, and the rest in the
first column is text, it will come into Access just one row.

Would you explain what is happening here?

Thanks,
B
Click to expand...

Access has much stronger datatyping than Excel. Since Access can't determine
the appropriate datatype from the properties of the spreadsheet, it must guess
by reading the first row (or first few rows).

I'd use File... Get External Data... Import rather than copy and paste; and
I'd create the table first, with the appropriate data types, so Access won't
have to guess. If that's impractical then you may need to insert a row at the
top of the range you're importing with "This Field Is Text" in the mixed
numeric and text column, just to whack Access upside the head.
 
Back
Top