[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1202
  • Last Modified:

Convert a *.TSV file for use in Access or Excel.

I'm trying to figure out how to convert a TSV file to ultimately use in Access. If I can get it converted for use in Excel first, that would be fine too. I have tried changing the extension to MDB, XLS, CSV, TXT, TAB - but no luck. ---Thanks
0
mapalaska2003
Asked:
mapalaska2003
  • 7
  • 6
  • 5
  • +2
3 Solutions
 
Jim P.Commented:
You have to import it into an access DB.

1) Create or open an access DB.
2) Right click in the tables and select Import/Link Tables
3) Change the Files of Type to Text files and then follow to your file.
        (Note that depending on your version of access and security you may have to rename the extension to "txt")
4) The wizard should step through the rest of it.
0
 
jefftwilleyCommented:
Excel will let you import it. Then you can save as excel or csv. Do you want to do this through code?
J
0
 
GRayLCommented:
Are you saying after you changed the file extension to .tab and clicked File, Import, and selected File types -
 Text files (*.text;*.csv;*.asc;*.log) and then browsed to the filename location and clicked on the file name, you were not taken to the import wizard?  
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
rockiroadsCommented:
Is your TSV a tab seperated value file?

if so, u should be able to import it, simply ensure the field delimiter is a tab

rename your file to .txt

then go to file/get external data/import

select delimited

click next, then select tab

then click next and follow steps


If not, then what type of file is it, is it something exported from something like quickbase?
0
 
rockiroadsCommented:
the others have given more or less what Ive said, Ive just posted to confirm what type of file u have

oh, by the way, like the others said, ensure u select type TEXTin the dropdown of import
0
 
mapalaska2003Author Commented:
First off, Thanks everyone.  But I still can't seem to get the data properly into access. Does sopmeone want to take a look at the file?
0
 
Jim P.Commented:
You can upload to here and then if you post the link back.
http://www.ee-stuff.com/Expert/Upload/upload.php
0
 
rockiroadsCommented:
sure, upload somewhere so we can download and check it out otherwise use http://www.ee-stuff.com/

0
 
rockiroadsCommented:
ditto jim :)
0
 
Jim P.Commented:
<off topic>
The preffered (now) is to put it at the ee-stuff there so we don't have dead links in the PAQ.
</off-topic>
0
 
mapalaska2003Author Commented:
Here is the link. The file is the (zipped) TSV file.  THANKS!!
0
 
mapalaska2003Author Commented:
0
 
mapalaska2003Author Commented:
0
 
rockiroadsCommented:
where was this file generated from? it seems it is written in a format understandable by that app only
it does not appear to be of any readable text format
0
 
jefftwilleyCommented:
It looks like a Binary dump of a database, maybe the Object Table or something. I don't have anything that will open it. Maybe a VI editor?
J
0
 
Jim P.Commented:
SSCE Database:

SQL Server 2000 CE Edition (SSCE) is a new "1.0 release" product from Microsoft and there is little information available outside the documentation. Another aspect of a 1.0 release is the lack of tools from the manufacturer and third parties. For anyone familiar with using SQL Server on the Desktop, and now looking to use SSCE, one tool that will be missed right away is Enterprise Manager. This article will cover some of the aspects of managing a database on the CE device and the tools that are available to make the job of managing database(s) easier.
0
 
mapalaska2003Author Commented:
Thanks everyone-have a nice weekend.
0
 
mapalaska2003Author Commented:
The file is from a proprietary application.
0
 
rockiroadsCommented:
does that application have some export procedure to csv?
TSV also stands for tab seperated which I thought it might be, but it may just be a file save/export in their own format.
0
 
mapalaska2003Author Commented:
No-not to CSV, only TSV.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 7
  • 6
  • 5
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now