Import multiple transactions on CSV to Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

I am in the process of writing recommandations for next year and was
wondering if this is something I can put on my "wish list". Let me
explain: we have this centralized inventory management database.
Everytime we do a transaction we have to include the "ship to"
location and "ship from" location. then, the user goes on the "details
tab" and can input all the items with the quantities. To sum up, on
transaction has one ship to and ship from location but has multiple
items.

Currently, we have the csv upload capability for the items only. If I
enter the Ship from and ship to on the main tab, when I go to the
details tab I can "upload from csv". So all the items on the csv will
be uploaded to the "details" window. The issue is that right now the
only information we can upload from the csv is the item ID and the
qty.

We recently introduced the barcode technology. The reader can produce
a csv report that shows all the locations, etc. but the issue is that
we can only upload the items and quantities, therefore I have to
create one CSV file for each location so I can upload them which
doesn't make any sense as it is too time consuming.

So my question is: is it possible to create a form, or find a way, to
import a csv file with all the information, and from there generate
many "shipping" transactions in access?

Thanks in advance,
Jonathan
.

Relevant Pages

  • RE: Import multiple transactions on CSV to Access
    ... you are currently importing one csv file per transaction ... Everytime we do a transaction we have to include the "ship to" ... we have the csv upload capability for the items only. ...
    (microsoft.public.access.externaldata)
  • Re: Import .csv File Problems
    ... As an alternative to renaming from csv to txt, ... text import wizard is to use Data/ Import External Data ... ... This will bring up the Imporet Wizard when you open the file with Excel. ... upload automatically in scientific format. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Saving CSV file to read from php
    ... Uploading is working fine, I could upload the .csv file to the server. ... When I saved the .csv file as Windows format in MS Excel, ...
    (comp.lang.php)
  • RE: Help with Text import and data extraction
    ... ' to open a new template to proceed to the next project ... I was also experimenting with saving as a csv in anticipation that he may ... ask for a csv fomat to upload. ... was aware that it's not as simple as saving as a csv within Excel. ...
    (microsoft.public.excel.misc)
  • Re: FS: TZ U$1.7500 but im in Argentine ...
    ... if anyone knows how i will do to ship to US. ... letme know, ... today i'm going to upload many pics to picassa. ...
    (rec.games.pinball)