Question: (Closed) Importing Vcf File To A Access Database Or A Sql Server Database
0
gravatar for User 3618
8.2 years ago by
User 36180
User 36180 wrote:

I have a VCF4 format file, I imported that file to excel and I deleted the meta information describing each column. Now I have data with respective column headers. Everything looks fine in excel, but when I imported it into Access 2007 or SQL Server table most of the records in many columns are not imported they are just blank. Can anyone please suggest me why this is happening? Is there any solution to import from excel to SQL Server as it is...Thanks!

vcf • 7.5k views
ADD COMMENTlink modified 8.2 years ago by Pierre Lindenbaum128k • written 8.2 years ago by User 36180
4

somewhere in the world, a bioinformatician is dying ;-)

ADD REPLYlink written 8.2 years ago by Pierre Lindenbaum128k

try to save your file in a text format (tsv, etc...) , check the quotes, try to only save a subset of your file, etc...

ADD REPLYlink written 8.2 years ago by Pierre Lindenbaum128k

I'll close that one: your problem is not strictly related to bioinformatics, You'll get some answers on stackoverflow.com or http://superuser.com/

ADD REPLYlink written 8.2 years ago by Pierre Lindenbaum128k
Please log in to add an answer.
The thread is closed. No new answers may be added.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1211 users visited in the last hour