Will problems mostly occur when import from Excel??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all....
I would like to ask i thought it would save time for me to import my old
data from Excel to Access....but it seems like "Data Type" cannot be change
that cause my code cant work......
Is there an easier way?
Do help me..its very urgent....Thank You....
 
Kelly

You could import to a "temporary" table from Excel, then use queries to
"load" permanent tables, using explicit conversion functions (see CCur(),
CInt(), CLng(), CStr(), etc.).
 
As jeff wrote, using type conversion functions will help clean up your data
as it comes in. You also should use the Nz() function around all fields you
think are numbers in Excel and want to bring into Access. This is because if
an Excel cell is formatted as "General" and not data has been entered, Access
will see it as Null. The Nz() function will correct that problems. Another
way to handle that problem is to go into the spreadsheet and format all cells
as some kind of number format. That way, Access will see blank cells as 0.
 
Back
Top