<div>
to be able to determine which records came from which file<br />
- add a field to your destination table and name it &quot;Source&quot;<br />
<br />
after the import line run an update query to update the &quot;source&quot; field with the filename of the source<br />
<br />
currentdb.execute &quot;update tablex set [source]= '&quot; &amp;&nbsp;fileName &amp;&nbsp;&quot;' where [source] is null&quot;
</div>


to be able to determine which records came from which file
- add a field to your destination table and name it "Source"

after the import line run an update query to update the "source" field with the filename of the source

currentdb.execute "update tablex set [source]= '" & fileName & "' where [source] is null"

<div>
After you import the data, add an autonumber column. &nbsp;That will be assigned based on the physical sequence of the data which presumably was the order in which it was imported.<br />
<br />
If you are appending to an existing table, make sure the table already has an autonumber defined.<br />
<br />
Later on, sorting by the autonumber column will give you data entry order.
</div>


After you import the data, add an autonumber column.  That will be assigned based on the physical sequence of the data which presumably was the order in which it was imported.

If you are appending to an existing table, make sure the table already has an autonumber defined.

Later on, sorting by the autonumber column will give you data entry order.

<div>
Pat Hartman -<br />
<br />
So as long as i have the auto number in the table that will be the order in which they where in the source file? If so that would be perfect for what i need.
</div>


Pat Hartman -

So as long as i have the auto number in the table that will be the order in which they where in the source file? If so that would be perfect for what i need.

<div>
<div class="content wysiwyg-content">
I have a import spec from a comma deliminated file. &nbsp;I need to load the items into the table in the order that they appeared in the .csv file. How?<br />
<br />
(or at least i have to have some way of determining where they where in the file)
</div>
</div>


I have a import spec from a comma deliminated file.  I need to load the items into the table in the order that they appeared in the .csv file. How?

(or at least i have to have some way of determining where they where in the file)

import spec: order in which they are loaded in the table

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.