Export Item List to Adjust

Posted by G E on August 16, 2006, 6:14 pm

Please log in for more thread options

I have imported a large group of inventory incorrectly (the bar code numbers
had spaces and shouldn't have). Is there a way to export a group of items
out into excel, so I can correct my error and re-import?

Posted by Jeff on August 17, 2006, 6:44 am

Please log in for more thread options

GE,

How about creating a SQL statement to remove the spaces.

Which field is the issue? ILC, Alias, Supplier Re-order #

--
=

Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader
to see and download the file attachment. If you are not using a reader,
follow the link below to setup Outlook Express. Click on "Open with
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz

==========

>I have imported a large group of inventory incorrectly (the bar code

>numbers

> had spaces and shouldn't have). Is there a way to export a group of items

> out into excel, so I can correct my error and re-import?

Posted by G E on August 17, 2006, 11:37 am

Please log in for more thread options

Sorry I'm new to all this. I have no idea how to create a SQL Statement. I
assume that means running a Query in the Administrator. However, I don't know
how to do that.

Posted by G E on August 17, 2006, 12:36 pm

Please log in for more thread options

I've learned a little bit about how to write a Query. However I still have
two problems.
1-Can I write a query that will bring up the item lookup codes for 1
specific Category or Department?
2-Once I get the information from the query I have no idea how to manipulate
the data. I know I can export it, but that does me no good if I can't import
the information.
Thanks for any help.

Posted by Glenn Adams [MVP - Retail Mgmt on August 17, 2006, 1:36 pm

Please log in for more thread options

You can use an UPDATE statement to set update many records at once - no
need to export the data and manipulate it just to remove spaces.

Jeff was asking which field has the data that need to be fixed so that
we know how to write the UPDATE statement...

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

G E wrote:

> I've learned a little bit about how to write a Query. However I still have

> two problems.

> 1-Can I write a query that will bring up the item lookup codes for 1

> specific Category or Department?

> 2-Once I get the information from the query I have no idea how to manipulate

> the data. I know I can export it, but that does me no good if I can't import

> the information.

> Thanks for any help.