Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dmcbrier
Starting Member
5 Posts |
 Posted - 2008-01-21 : 22:33:18
|
I have a export file in the following format.... See belowExport Contact Record AccountNo and Notes. The Primary Key uses every charater on the keyboard but | and ~ so I have choosen to use those as export. The only way to get the data out of Goldmine Version 5 Database is via ASCII Export.I used field seperator ~I used field delimiter |Record Separator CR/LFHow do I get this DOS file into SQL 2000 or excel?My database has 5000 records ... 2000 have notes.Below is a rough example of some of the data.Not sure what to do here. Is there a way to get into excel?Is there a way to get into SQL. Where do I even begin? Thank you. |ACCOUNTNO|~|NOTES||A3070957146(_QF*BTim|~|||A4040249115%ZL4*&Ade|~|||99102842004#9Z@ZIADT|~|||98020942287410129Adv|~|||A4043042548%K7O+1Ric|~|||99102842060%:+]4IADV|~|||A5050941610%%EXRYAMC|~|*** DMCBRIER *** May 9, 2005 at 11:36am 3/30/2006 Dropped off Literature Package / 50th Mug / 50th Post-It-NotesVery Near Future Expanding Building (Darryl Neil did not know the details) Advanced Monolythic Ceramics (AMC) designs, produces and ships customized filter capacitors used in high-reliability applications inside cable connectors. AMC currently occupies 8,000 sf of the UCC. With the addition of the UCC, AMC expanded into 4,000 new sf and will create 20 additional jobs.University Commerce Centre (UCC), built in 1997, was conceived to strengthen regional capacity to accommodate small-business expansion by providing reasonably priced, flexible space where technical assistance and business consultation would be available. The current facility has two tenants Advanced Monolythic Ceramics and Paragon Foods. April 2000 construction began on an 8,000 square foot addition at the UCC. ||99102842135)]R%%IAET|~|This is sample text example||A3091056569#9044ECol|~|This is sample text example||99102842231#%{8*IAFF|~|||A4030842091$:\V.-BIL|~|*** JCHIMERA *** March 8, 2004 at 11:43am TOOL & DIE SHOP||98030639320441966AGN|~|||A4040640499$D$@W]|~|*** DAVIDM *** April 6, 2004 at 11:15am Home Builders Association Board Member: Paul Agnew||A3091155805%:P&9EJim|~|||98030635961421062AHL|~|*** MPAINTER *** May 8, 2001 at 10:25am 1997 SALES [$1,778] 1998 SALES [$1,679] 1999 SALES [$.00]2000 SALES [$.00]2001 $02002 $02003 $02004 $2572005 $0||98082056181*LF6O=AHR|~|*** DMCBRIER *** August 25, 2005 at 3:49pm Sales 2000 $0Sales 2001 $0Sales 2002 $0Sales 2003 $0Small General Contractor| |
|
|
|
|
|
|
|
ASCII CR LF Export File need to import