Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Database > converting excel worksheets to access tables

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

converting excel worksheets to access tables

Reply to Message Icon

Name: excelbaby
Date: June 4, 2009 at 03:03:06 Pacific
OS: Windows XP
Subcategory: General
Comment:

I loose some data when converting from text..even when I change the format.. example size column in excel worksheet is formated as text.. but when converted to acces only the size field is number, and text data is lost



Sponsored Link
Ads by Google

Response Number 1
Name: David Perry
Date: June 4, 2009 at 11:21:59 Pacific
Reply:

Are you able to use any tools like Perl that could read this as a datasource and import to access rather than doing an export to something that won't maintain extended information?


0
Reply to Message Icon

Related Posts

See More


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links
Ads by Google


Results for: converting excel worksheets to access tables
Multiple Excel Worksheets to Access www.computing.net/answers/dbase/multiple-excel-worksheets-to-access/115.html

Convert Excel to Access database www.computing.net/answers/dbase/convert-excel-to-access-database/39.html

Import Excel to Access 2000 www.computing.net/answers/dbase/import-excel-to-access-2000/451.html