Import From Excel

P

PAL

I am a new user. I am trying to import from excel. Columns are text,
numbers and dates.

When importing, I get an error, "Methed Coloms of Obmect ILMex Grid Failed"
and I noticed that I get numbers instead of dates. What I change the type
for the dates to Date/Time, nothing happens. Ideas.

Also, my spreadsheet does have blank dates? Is this the problem. Do I have
to put dummy data in or a symbol.

Thanks.
 
P

PieterLinden via AccessMonster.com

PAL said:
I am a new user. I am trying to import from excel. Columns are text,
numbers and dates.

When importing, I get an error, "Methed Coloms of Obmect ILMex Grid Failed"
and I noticed that I get numbers instead of dates. What I change the type
for the dates to Date/Time, nothing happens. Ideas.

Also, my spreadsheet does have blank dates? Is this the problem. Do I have
to put dummy data in or a symbol.

Thanks.
Click to expand...

What happens if you
(1) import into an existing table?
(2) import into an existing table where all the fields are text? (because you
can put any data in there, regardless of type)
 
Top