Importing a file format that access does not support

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using VBA to import a file in Access 97. When I converted the database
to Access 2002, the import does not work because it does not have the proper
extension. Can I force the import using either an import VBA method or using
a macro?
 
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
 
Back
Top