Access And Excel Weird Behavior While Importing

[Kherozen]

Hi,
I'm currently trying to import data from excel spreadsheet to Access Tables and I have been running into some weird behavior. ok is it normal that I can't import more than 20 records... if I put more Access tell me that descriptive error message "an error occured while importing "import.xls" ..." and after I imported that small amount of records, I'm able to import bigger files BUT I can't open any excel files without having to reboot

any idea what could cause those problem?

I'm using Excel 2002, Access 2002 and my Database is on MSDE 2000


jul ^_^
"Computer Science is no more about computers than astronomy is about telescopes"
E. W. Dijkstra.

 

[AJD10]

I don't use 2002, so I'm not sure if there's something weird with that. Are all your data types the same as in the table you're trying to import? Are there primary key fields that are blank?

Oh - another plm I had recently with an XLS I was importing into the mdb was resolved when I left the XLS open while I imported. (even microsoft site said that was all i needed to do) Thought they would've fixed it by now (I'm in Office 97)

Hope something works for you. <

 

[Kherozen]

Data types are ok
and primary key fields are not blank in the xls files

I'd thought about letting open the xls files during the import but that didn't do it ...

but the thing tat is weird is that I can't open in xls files after I successed an import until I reboot.


jul ^_^
&quot;Computer Science is no more about computers than astronomy is about telescopes&quot;
E. W. Dijkstra.