Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting ICITEM Records

Status
Not open for further replies.
tslee1975

tslee1975

Technical User
Sep 5, 2008
6
SG
I need to export records from various IC tables and import them to another database later. I can get the required ITEMNO from SQL Server, but how do I export the required records in CSV or Excel format? I created and save a script, modify it and tried to load it back. It always fail to load, I suspect that there's too many "Criteria" listed (about 44K+). What would be the best way to do this task at hand?
 
Sort by date Sort by votes
Are you exporting from SQL or using Accpac's export functionality?
 
Upvote 0 Downvote
The best way to achieve this would be by running a query to extract the data rather than exporting, if you know how to do that.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

vbdbcoder
  • Locked
  • Question
Update Account Set Code in ICITEM and Transactions
Replies
1
Views
99
ettienne
ettienne
Mab-a
  • Locked
  • Question
build a list of records not in contract table given row column excel record
Replies
2
Views
119
Mab-a
Mab-a
hushman
  • Locked
  • Question
Exporting File for Bank Debit Orders
Replies
1
Views
76
Jay Converse
Jay Converse
PhilDOakley
  • Locked
  • Question
How to create restart records in Macro VBA
Replies
6
Views
108
ettienne
ettienne
vbdbcoder
  • Locked
  • Question
Ksync query returns records, but not sending out Email Alerts in the application events 1
Replies
9
Views
123
vbdbcoder
vbdbcoder

Part and Inventory Search

Sponsor

Back
Top