<div>
And what if they are different...?<br />
...then what?<br />
<br />
Are you comparing all subsequent files to one standard (reference) file, ...or are you wanting to just compare the file being imported to the previous file?
</div>


And what if they are different...?
...then what?

Are you comparing all subsequent files to one standard (reference) file, ...or are you wanting to just compare the file being imported to the previous file?

<div>
JC, just trying to compare the header of the new file with what I expected to see.
</div>


JC, just trying to compare the header of the new file with what I expected to see.

<div>
So comparing a &quot;Reference&quot; header to the current header? &nbsp;Correct?
</div>


So comparing a "Reference" header to the current header?  Correct?

<div>
I use Nick's method, but not the file system object. &nbsp; I just use an Open and a Input in VBA.<br />
<br />
Jim.
</div>


I use Nick's method, but not the file system object.   I just use an Open and a Input in VBA.

Jim.

<div>
Jim,<br />
Would you have some example code showing that?<br />
Thanks
</div>


Jim,
Would you have some example code showing that?
Thanks

<div>
<div class="content wysiwyg-content">
A company leaves a csv file on a server every night. A script downloads it and then an Access 2000 MDB attempts to import it with an Import Specification.<br />
<br />
However, the company may change the header at any time, including changing the order of the fields, names of the fields, or adding or deleting fields. This happens rarely.<br />
<br />
What is a way to check the header of the csv file first, perhaps by comparing it to a saved version?
</div>
</div>


A company leaves a csv file on a server every night. A script downloads it and then an Access 2000 MDB attempts to import it with an Import Specification.

However, the company may change the header at any time, including changing the order of the fields, names of the fields, or adding or deleting fields. This happens rarely.

What is a way to check the header of the csv file first, perhaps by comparing it to a saved version?

How to check csv header before Access 2000 import?

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.

Microsoft Access

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.

Windows Batch

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.