kilroyscarnival
Registered User.
- Local time
- Today, 16:45
- Joined
- Mar 6, 2002
- Messages
- 76
Does this happen to anyone else here?
I've pulled some data into Excel from other software. The column headers are made the same as in my existing Access table. I set my print area, save the Excel workbook, close, and then try to import in Access. And the import dialogue won't recognize my print area as a valid range! So the import attempt fails or else it imports a bunch of blank rows. Not 100% of the time but often enough to bother me.
I am using Excel 2000 and Access 2000 on a Windows 98 computer. I've tried saving as an Excel 4.0 worksheet but that doesn't work either.
Thanks!
--Ann
I've pulled some data into Excel from other software. The column headers are made the same as in my existing Access table. I set my print area, save the Excel workbook, close, and then try to import in Access. And the import dialogue won't recognize my print area as a valid range! So the import attempt fails or else it imports a bunch of blank rows. Not 100% of the time but often enough to bother me.
I am using Excel 2000 and Access 2000 on a Windows 98 computer. I've tried saving as an Excel 4.0 worksheet but that doesn't work either.
Thanks!
--Ann