Problem importing .dbf file that has index file in .nsx format 1

[SockMonkey]

I have some .dbf files that are using .nsx extension index file. <br>Does anyone know what i need to add to Access or ODBC in order to import these files?<br>I can view the .dbf file in a .dbf viewer but that is about it.<br>Thanks in advance!

 

[DougP]

1. Click the &quot;Tables&quot; tab<br>2. Right click in the white space.<br>3. Click &quot;Import&quot;<br>4. In the &quot;Files of Type&quot; (at the bottom) find your Type &quot;.dbf&quot; etc.<br>5. Click the &quot;Import&quot; button<br>6. If there is an Index file it will prompt you for it.<br><br>Then it will add the .dbf file to your Access database

 

[SockMonkey]

I have tried that already with all the different dbf formats that are listed and none of them work.<br><br>I believe this database file is an xbase .dbf used with a program written in C++.

 

[DougP]

So are you getting an Error?<br>Did you try all of the Dbase's III IV and V?<br>Did you try importing it as FoxPro???

 

[MJA15]

Another option would be to open the dbf in MS Excel and then save it in an Excel format. You can the import this file into Access.<br><br>There are three minor problems that need to be dealt with when using this method.<br><br>1. When you open an xbase file in Excel, sometimes it will change the format for date fields to character. All memo fields will be seen as character fields as well.<br><br>2. You will lose the contents of any memo fields for the table.<br><br>3. You will need to manually recreate the associated indexes for the table.<br><br>I know this isn't the most efficient way of doing things but if you end up running out of ideas or time it's always an option.

 

[SockMonkey]

I tried all of those options<br>&nbsp;The error message I get is &quot;External table isnt in the expected format&quot;<br>As I mentioned I can read the file with no problem in a raw DBF viewer program but that program doesnt allow me to do anything else with the data

 

[toptech]

Hi There.

Has anyone solved this problem yet?

I am currently grappling with this exact problem.


Regards,

TopTech Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.