Has anyone been able to import files from government data base .g.

S

Steve

I am trying to import a government database into Access 2000. Access doesn't
recognize the extension. Are there downloads or other means to accomplish
this? Getting information from government sources seems like it should be a
common occurance.
 
J

Joe Fallon

Not enough info to give a good response.

The govt does not have a classified file format.
(Well it might but then ....)

Anyway, you need to explain what kind of file it is (text, Excel, Access,
Foxpro, dBase....)

Sometimes you can simply change the extension.
e.g. the govt uses .gov for text files so you change it to .txt and then it
imports into Access.

======================================================

Check out the following KB articles for an explanation, and how to get
around it:

ACC97: "Can't Update. Database or Object Is Read-only" Error Message When
You Import Files
http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q247861

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import Files
http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q245407

ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize (Q306144)
http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q306144
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import to Access from Excel - database exists, not all fields match 3
Importing data from Tables into Forms 1
Export/Import .dat file extension 2
problems importing a Paradox file into Access 2003 4
Importing data from excel spreadsheet 2
Importing Data and AUTONUM issues 1
lookup value from a table based on two conditions 3
Delete 'mystery' character from data (possibly carriage return) 2

Top