How do I import a text WRK file into Access?

[Guest]

I have a file which has been received from the USPS for address information
and converted using the tools from the USPS into 930 WRK files. I can open
these files in Excel, but have found no method to open them in Access...where
I need them.

These files are fixed length text files without delimiters.

Thanks
Charles

 

[Pat Hartman\(MVP\)]

You may have to rename the .wrk extension to .txt. Some security
"enhancement" was made to Access/Jet a few years ago that makes it
impossible to read files with non-standard file types. Once you change the
extension, you can use the import wizard to create an import spec. Save the
import spec and then you can automate the import by using the TransferText
Method. You will also need to automate the rename in VBA also. I don't
remember the syntax but I think the command is "Name" rather than "Rename".