 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / June 2005Importing a huge excel spread sheet into Outlook
I have a database of 2549 records that I want to import into outlook. It doesn't seem to go through. I go through all of the wizard steps, but when I choose the mapping function, it stalls. Is it because there are too many records or in some of the records, not all of the fields are filled?  SignatureBill What database (and version thereof) are you using? What version of Outlook? What do you mean by "it stalls"? What exactly happens (or doesn't happen as the case may be)? 2500+ records is not a big number in terms of import size. Karl __________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com >I have a database of 2549 records that I want to import into outlook. It > doesn't seem to go through. I go through all of the wizard steps, but > when I > choose the mapping function, it stalls. Is it because there are too many > records or in some of the records, not all of the fields are filled? I have Outlook 2000 and the database is in an excel spread sheet. For some reason the mapping function stalls. I just deleted a number of unusable records, (duplicates, etc.) thinkin that might help. What am I doing wrong? > What database (and version thereof) are you using? What version of Outlook? > What do you mean by "it stalls"? What exactly happens (or doesn't happen as [quoted text clipped - 15 lines] > > choose the mapping function, it stalls. Is it because there are too many > > records or in some of the records, not all of the fields are filled? Still have no clue as to what you mean by the "mapping function stalls". Just hangs? Any error messages? The term "mapping" to means - during the process where you indicate all the information is to be used but before any data is being imported - ergo, if that's the case - would need info on where you're at exactly. The term "importing" means that the process of moving data from your source file to the Outlook folder has started - in which case, has anything been imported? If yes, first thing to do is compare what made it in and where that record resides in your Excel file - the record immediately following it would be the first thing I'd look at. If nothing got imported - your header row would be the suspect line. Finally, in terms of Excel, we've run across more then one corrupt Excel file that was only usable within Excel but couldn't be read properly otherwise either by Outlook or any of our products (which is how we ran across them). Once we reconstructed the spreadsheet - problems all disappeared. If you save your data to CSV format - can you import the CSV file. IF you re-opened this CSV file in Excel - added a new named range for all your data, save it as an Excel file - does the new Excel file exhibit the same issues? Karl __________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com >I have Outlook 2000 and the database is in an excel spread sheet. For some > reason the mapping function stalls. I just deleted a number of unusable [quoted text clipped - 24 lines] >> > many >> > records or in some of the records, not all of the fields are filled? Re-read the subject line right after sending the previous response - so further to my previous answer- First thing to check the named range you're using making sure that it covers all the data you want to import including the header row (you do have one right?). Alternatively, just save the worksheet as a CSV file an import that file instead which eliminates the Excel named range issue. Karl __________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com >I have a database of 2549 records that I want to import into outlook. It > doesn't seem to go through. I go through all of the wizard steps, but > when I > choose the mapping function, it stalls. Is it because there are too many > records or in some of the records, not all of the fields are filled? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.