Importing data from excel problems (v16)

Database
Enthusiast

Importing data from excel problems (v16)

Hi community, 

 

I've found several problems importing data from excel:

a) destination table must be float for numerics, otherwise it will be filled with nulls

 

b) won't accept number formating: must be "general", otherwise it will be filled with nulls

 

c) no warnings: in either cases described, the process of importing runs without warning

 

Hope can fix this issues soon