Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hello,
Create new database in Access and select File / Get external Data, select your txt. source and follow the wizard instuctions. This is for Acess 2003. After that table will be created from your txt file and you can make query on it.
| | | ---------------Original Message---------------
From: sha-m
Sent: Sunday, January 16, 2011 9:17 AM
Subject: COOIS: Cannot export data to Spreadsheet or Excel
Good day everyone,
I executed COOIS for Production Order Components Data. I have about 100,000 to 200,000 data. I cannot export or save to local file in spreadsheet or excel format due to limitation of excel lines. But I can export it to .txt format. The issue is:
I need to upload this .txt format into access and I need guidance in doing this. Could anyone of you advise me how to upload this .txt format into Access? Or is there any other way that I can export this COOIS data into Access?
Thank you in advance.
Best regards,
Sha |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Most Popular White Papers
In the Spotlight  _.____.__ |
