How does one import a .tsv file directly into Microsoft Access without using Excel? Thank you.
J Janet Sep 23, 2005 #1 How does one import a .tsv file directly into Microsoft Access without using Excel? Thank you.
J John Nurick Sep 23, 2005 #2 The simplest way (if tsv means what I think it does) is to rename it ..txt or .tab. Otherwise, this http://support.microsoft.com/?id=304206 shows how to change the extensions that Access will accept, and this http://support.microsoft.com/?id=306144 includes code that automatically makes a copy of the textfile with a .txt extension and imports that.
The simplest way (if tsv means what I think it does) is to rename it ..txt or .tab. Otherwise, this http://support.microsoft.com/?id=304206 shows how to change the extensions that Access will accept, and this http://support.microsoft.com/?id=306144 includes code that automatically makes a copy of the textfile with a .txt extension and imports that.
