Help With BCP Import
Jul 13, 2007
Hello, Let get right to it, OK?
Setup:
Windows 2003 web edition w/ SQL Express
Problem:
Error when importing text file to SQL Express. Not sure about the quality of the data since it is from a 3rd party and has over 1700 rows but it imports in to MS Access with no problems.
Error:
Unable to open BCP host data-file
Command:
bcp MLS_Data.dbo.tblFL_PuntaGorda in C:InetpubAdminScriptsDL_MLSpuntagorda_data.txt -T -S.SQLEXPRESS -f FL_PuntaGorda_bcp.fmt
Format File:
9.0
88
1 SQLCHAR 0 1 """ 0 Quote SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 50 "","" 1 MLS_ID SQL_Latin1_General_CP1_CI_AS
3 SQLCHAR 0 50 "","" 2 MLS_STATE_ID SQL_Latin1_General_CP1_CI_AS
4 SQLCHAR 0 50 "","" 3 MLS_LISTING_ID SQL_Latin1_General_CP1_CI_AS
5 SQLCHAR 0 50 "","" 4 TLN_FIRM_ID SQL_Latin1_General_CP1_CI_AS
6 SQLCHAR 0 150 "","" 5 MLS_OFFICE_NAME SQL_Latin1_General_CP1_CI_AS
7 SQLCHAR 0 50 "","" 6 MLS_OFFICE_PHON SQL_Latin1_General_CP1_CI_AS
8 SQLCHAR 0 50 "","" 7 TLN_REALTOR_ID SQL_Latin1_General_CP1_CI_AS
9 SQLCHAR 0 50 "","" 8 MLS_AGENT_NAME SQL_Latin1_General_CP1_CI_AS
10 SQLCHAR 0 50 "","" 9 MLS_AGENT_PHONE SQL_Latin1_General_CP1_CI_AS
11 SQLCHAR 0 50 "","" 10 LISTING_DATE SQL_Latin1_General_CP1_CI_AS
12 SQLCHAR 0 50 "","" 11 LISTING_EXPIRATION_DATE SQL_Latin1_General_CP1_CI_AS
13 SQLCHAR 0 50 "","" 12 SOLD_DATE SQL_Latin1_General_CP1_CI_AS
14 SQLCHAR 0 50 "","" 13 AVAILABLE_DATE SQL_Latin1_General_CP1_CI_AS
15 SQLCHAR 0 50 "","" 14 PROPERTY_TYPE_CODE SQL_Latin1_General_CP1_CI_AS
16 SQLCHAR 0 50 "","" 15 PROP_TYPE_DESCRIPTION SQL_Latin1_General_CP1_CI_AS
17 SQLCHAR 0 16000 "","" 16 REMARKS SQL_Latin1_General_CP1_CI_AS
18 SQLCHAR 0 50 "","" 17 STATUS_CODE SQL_Latin1_General_CP1_CI_AS
19 SQLCHAR 0 50 "","" 18 SALE_PRICE SQL_Latin1_General_CP1_CI_AS
20 SQLCHAR 0 50 "","" 19 SOLD_PRICE SQL_Latin1_General_CP1_CI_AS
21 SQLCHAR 0 50 "","" 20 PROPERTY_STATE_ID SQL_Latin1_General_CP1_CI_AS
22 SQLCHAR 0 50 "","" 21 STREET_NUMBER SQL_Latin1_General_CP1_CI_AS
23 SQLCHAR 0 50 "","" 22 STREET_NAME SQL_Latin1_General_CP1_CI_AS
24 SQLCHAR 0 50 "","" 23 STREET_TYPE SQL_Latin1_General_CP1_CI_AS
25 SQLCHAR 0 50 "","" 24 STREET_DIRECTION SQL_Latin1_General_CP1_CI_AS
26 SQLCHAR 0 50 "","" 25 UNIT_NUMBER SQL_Latin1_General_CP1_CI_AS
27 SQLCHAR 0 50 "","" 26 LONGITUDE SQL_Latin1_General_CP1_CI_AS
28 SQLCHAR 0 50 "","" 27 LATITUDE SQL_Latin1_General_CP1_CI_AS
29 SQLCHAR 0 50 "","" 28 CITY SQL_Latin1_General_CP1_CI_AS
30 SQLCHAR 0 50 "","" 29 CITY_ID SQL_Latin1_General_CP1_CI_AS
31 SQLCHAR 0 50 "","" 30 ZIP_CODE SQL_Latin1_General_CP1_CI_AS
32 SQLCHAR 0 50 "","" 31 ZIP_PLUS4 SQL_Latin1_General_CP1_CI_AS
33 SQLCHAR 0 50 "","" 32 MLS_AREA SQL_Latin1_General_CP1_CI_AS
34 SQLCHAR 0 50 "","" 33 COUNTY SQL_Latin1_General_CP1_CI_AS
35 SQLCHAR 0 50 "","" 34 FIPS_COUNTY_CODE SQL_Latin1_General_CP1_CI_AS
36 SQLCHAR 0 50 "","" 35 SUBDIVISION SQL_Latin1_General_CP1_CI_AS
37 SQLCHAR 0 50 "","" 36 COMMUNITY_NAME SQL_Latin1_General_CP1_CI_AS
38 SQLCHAR 0 50 "","" 37 YEAR_BUILT SQL_Latin1_General_CP1_CI_AS
39 SQLCHAR 0 50 "","" 38 ACRES SQL_Latin1_General_CP1_CI_AS
40 SQLCHAR 0 50 "","" 39 LOT_DIMENSIONS SQL_Latin1_General_CP1_CI_AS
41 SQLCHAR 0 50 "","" 40 LOT_SQUARE_FOOTAGE SQL_Latin1_General_CP1_CI_AS
42 SQLCHAR 0 50 "","" 41 LOT_SQUARE_FOOTAGE_LAND SQL_Latin1_General_CP1_CI_AS
43 SQLCHAR 0 50 "","" 42 BUILDING_SQUARE_FOOTAGE SQL_Latin1_General_CP1_CI_AS
44 SQLCHAR 0 50 "","" 43 BEDROOMS SQL_Latin1_General_CP1_CI_AS
45 SQLCHAR 0 50 "","" 44 BATHS_TOTAL SQL_Latin1_General_CP1_CI_AS
46 SQLCHAR 0 50 "","" 45 BATHS_FULL SQL_Latin1_General_CP1_CI_AS
47 SQLCHAR 0 50 "","" 46 BATHS_HALF SQL_Latin1_General_CP1_CI_AS
48 SQLCHAR 0 50 "","" 47 BATHS_THREE_QUARTER SQL_Latin1_General_CP1_CI_AS
49 SQLCHAR 0 50 "","" 48 FIREPLACE_NUMBER SQL_Latin1_General_CP1_CI_AS
50 SQLCHAR 0 50 "","" 49 TOTAL_ROOMS SQL_Latin1_General_CP1_CI_AS
51 SQLCHAR 0 50 "","" 50 SCHOOL_DISTRICT SQL_Latin1_General_CP1_CI_AS
52 SQLCHAR 0 50 "","" 51 SCHOOL_ELEMENTARY SQL_Latin1_General_CP1_CI_AS
53 SQLCHAR 0 50 "","" 52 SCHOOL_MIDDLE SQL_Latin1_General_CP1_CI_AS
54 SQLCHAR 0 50 "","" 53 SCHOOL_JUNIOR_HIGH SQL_Latin1_General_CP1_CI_AS
55 SQLCHAR 0 50 "","" 54 SCHOOL_HIGH SQL_Latin1_General_CP1_CI_AS
56 SQLCHAR 0 50 "","" 55 TOTAL_UNITS SQL_Latin1_General_CP1_CI_AS
57 SQLCHAR 0 50 "","" 56 TOTAL_BUILDINGS SQL_Latin1_General_CP1_CI_AS
58 SQLCHAR 0 50 "","" 57 TOTAL_LOTS SQL_Latin1_General_CP1_CI_AS
59 SQLCHAR 0 50 "","" 58 HOA_FEES SQL_Latin1_General_CP1_CI_AS
60 SQLCHAR 0 50 "","" 59 OWNERS_NAME SQL_Latin1_General_CP1_CI_AS
61 SQLCHAR 0 750 "","" 60 LEGAL SQL_Latin1_General_CP1_CI_AS
62 SQLCHAR 0 50 "","" 61 APN SQL_Latin1_General_CP1_CI_AS
63 SQLCHAR 0 50 "","" 62 TAXES SQL_Latin1_General_CP1_CI_AS
64 SQLCHAR 0 50 "","" 63 TAX_YEAR SQL_Latin1_General_CP1_CI_AS
65 SQLCHAR 0 50 "","" 64 SECTION SQL_Latin1_General_CP1_CI_AS
66 SQLCHAR 0 50 "","" 65 RANGE SQL_Latin1_General_CP1_CI_AS
67 SQLCHAR 0 50 "","" 66 TOWNSHIP SQL_Latin1_General_CP1_CI_AS
68 SQLCHAR 0 50 "","" 67 RENT_ON_SEASON SQL_Latin1_General_CP1_CI_AS
69 SQLCHAR 0 50 "","" 68 RENT_OFF_SEASON SQL_Latin1_General_CP1_CI_AS
70 SQLCHAR 0 50 "","" 69 PHOTO_IND SQL_Latin1_General_CP1_CI_AS
71 SQLCHAR 0 50 "","" 70 LAST_MLS_UPDATE_DATE SQL_Latin1_General_CP1_CI_AS
72 SQLCHAR 0 50 "","" 71 MASTER_BED SQL_Latin1_General_CP1_CI_AS
73 SQLCHAR 0 50 "","" 72 BED2 SQL_Latin1_General_CP1_CI_AS
74 SQLCHAR 0 50 "","" 73 BED3 SQL_Latin1_General_CP1_CI_AS
75 SQLCHAR 0 50 "","" 74 BED4 SQL_Latin1_General_CP1_CI_AS
76 SQLCHAR 0 50 "","" 75 BED5 SQL_Latin1_General_CP1_CI_AS
77 SQLCHAR 0 50 "","" 76 KITCHEN SQL_Latin1_General_CP1_CI_AS
78 SQLCHAR 0 50 "","" 77 BREAKFAST SQL_Latin1_General_CP1_CI_AS
79 SQLCHAR 0 50 "","" 78 LAUNDRY SQL_Latin1_General_CP1_CI_AS
80 SQLCHAR 0 50 "","" 79 DEN SQL_Latin1_General_CP1_CI_AS
81 SQLCHAR 0 50 "","" 80 DINING SQL_Latin1_General_CP1_CI_AS
82 SQLCHAR 0 50 "","" 81 FAMILY SQL_Latin1_General_CP1_CI_AS
83 SQLCHAR 0 50 "","" 82 LIVING SQL_Latin1_General_CP1_CI_AS
84 SQLCHAR 0 50 "","" 83 GREAT SQL_Latin1_General_CP1_CI_AS
85 SQLCHAR 0 50 "","" 84 EXTRA SQL_Latin1_General_CP1_CI_AS
86 SQLCHAR 0 16000 "","" 85 FEATURE_CODES SQL_Latin1_General_CP1_CI_AS
87 SQLCHAR 0 50 "","" 86 MLS_OFFICE_ID SQL_Latin1_General_CP1_CI_AS
88 SQLCHAR 0 50 "","" 87 MLS_AGENT_ID SQL_Latin1_General_CP1_CI_AS
89 SQLCHAR 0 200 ""
" 88 VIRTUAL_TOUR_URL SQL_Latin1_General_CP1_CI_AS
Please help,
Shawn
View 6 Replies
ADVERTISEMENT
Feb 25, 2008
A view named "Viw_Labour_Cost_By_Service_Order_No" has been created and can be run successfully on the server.
I want to import the data which draws from the view to a table using SQL Server Import and Export Wizard.
However, when I run the wizard on the server, it gives me the following error message and stop on the step Setting Source Connection
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Error)
Messages
Error 0xc020801c: Source - Viw_Labour_Cost_By_Service_Order_No [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0014019. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
(SQL Server Import and Export Wizard)
Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)
- Setting Destination Connection (Stopped)
- Validating (Stopped)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Stopped)
- Copying to [NAV_CSG].[dbo].[Report_Labour_Cost_By_Service_Order_No] (Stopped)
- Post-execute (Stopped)
Does anyone encounter this problem before and know what is happening?
Thanks for kindly reply.
Best regards,
Calvin Lam
View 6 Replies
View Related
Jul 29, 2015
I am trying to import an xlsx spreadsheet into a sql 2008 r2 database using the SSMS Import Wizard. When pointed to the spreadsheet ("choose a data source")  the Import Wizard returns this error:
"The operation could not be completed" The Microsoft ACE.OLEDB.12.0 provider is not registered on the local machine (System.Data)
How can I address that issue? (e.g. Where is this provider and how do I install it?)
View 2 Replies
View Related
Oct 16, 2006
I am attempting to import data from Microsoft Access databases to SQL Server 2000 using the DTS Import/Export Wizard. I have a few errors.
Error at Destination for Row number 1. Errors encountered so far in this task: 1.
Insert error column 152 ('ViewMentalTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 150 ('VRptTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 147 ('ViewAppTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 144 ('VPreTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 15 ('Time', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Could you please look into this and guide me
Thanks in advance
venkatesh
imtesh@gmail.com
View 4 Replies
View Related
Nov 29, 2006
I am trying to simplify a query given to me by one of my collegues written using the query designer of Access. Looking at the query there seem to be some syntax differences, so to see if this was the case I thought I would import the database to my SQL Server Developer edition.
I tried to start the wizard from within SQL Server Management Studio Express as shown in one of the articles on MSDN which did not work, but the manual method also suggested did work.
Trouble is that it gets most of the way through the import until it spews forth the following error messages:
- Prepare for Execute (Error)
Messages
Error 0xc0202009: {332B4EB1-AF51-4FFF-A3C9-3AEE594FCB11}: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Could not start session. Too many sessions already active.".
(SQL Server Import and Export Wizard)
Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.
(SQL Server Import and Export Wizard)
Error 0xc004701a: Data Flow Task: component "Source 33 - ATable" (2065) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard).
There does not seem to be any method of specifying a number of sessions, so I don't see how to get round the problem.
Does anyone know how I can get the import to work?
View 2 Replies
View Related
Jan 7, 2004
Hello:
I am not sure how to implement the following, but I believe it entails using DTS, and hopefully it is fine that I post it here b/c ultimately I will need this backend data for my frontend .aspx pages:
On a weekly basis, I need to IMPORT some data located on a remote Oracle DB into SQL Server 2k. Since there is so much data to transfer, I would only like to transfer the data that is new to the table since the last IMPORT, i.e. a week ago and leave behin the OLD data.
Is DTS the correct way to go or do I have more control via DTS with STORED PROCEDURES? Does anyone have any good references for me?
On a similar note, once this Oracle data is IMPORTED into a certain table, I would like to EXPORT some of these NEWLY acquired rows matching certain criteria into another table for auditing purposes. For this scenario, should I implement a TRIGGER UPDATE event here on the first table?
Any advice will be greatly appreciated!
View 3 Replies
View Related
Jan 12, 2006
Hi all,
when trying to Ãmport files to our database server from a client, I keep getting an error:
- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source_txt" (1).
(SQL Server Import and Export Wizard)
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (175).
(SQL Server Import and Export Wizard)
... doing the same import when logged on the server, hasn't been giving me any errors, how come. I can from my client without trouble import tables from other DB servers but when ever it is files it won't do it.
I tried as mentioned in other threads rerun setup to re-install SSIS, but as it was already installed it wouldn't re-install. My next move would be to make a clean install, but not sure it would help, as I think this is a buck.
best regards
Musa Rusid
View 1 Replies
View Related
Jul 23, 2005
Hi,I am having trouble importing data from an excel spreadsheet into MSSQL Server 2000 using DTS Wizard. The DTS import process issuccessfull, no errors, but only 50 rows of approx. 1500 rows of dataare imported. I tried to remove 20 rows in the excel spreadsheet inthe interval row 0-50. When i later ran the import, only 30 rows wereimported. I deleted almost every row in the interval 0-50, with theresult of the import having 0 rows imported (but job ransuccessfully). I decided to delete rows 0-100 in the spreadsheet inorder to see if the resolved the problem, but it didn't. As Isuspected something in the excel file to be the cause, I exported theexcel spreadsheeet to a tab delimited textfile, with only one row. ADTS import resulted in importing approx 100 rows, double the amount ofthe textfile, but the other 1400 rows were not imported. The data inthe column is containing numeric values only.Please help me! What could possibly be the cause of DTS skipping rowslike that. DTS doesn't feel reliable at all :/Regards,Björn
View 3 Replies
View Related
Apr 14, 2008
What is the method or methods for importing delimited text files to SQLEXPRESS 2005 database?
View 5 Replies
View Related
Jun 9, 2008
I have some c# code where I import data to SQL from an xml file. Can this be done with type Image? I test for it and turn the gobbly gook into a byte[] array, but I get an out of memory error on my c# app when I try to view it.
Is this possible?
View 4 Replies
View Related
Apr 9, 2004
I have a text file that I must import into a table I created but am having terrible difficulty trying to use the command line BCP utility to do so. Can anyone please tell me how to do this?
Text file and table properties below:
Text File
1
Untitled
Mark Rothko
Oil
1961
5'9"x4'2"
2
The Letter
Jan Vermeer
Oil
1666
1'5.25"x1'3.75"
3
Four Apostles
Albrecht Durer
Oil
1526
7'1"x2'6"
4
Big Self-Portrait
Chuck Close
Acrylic
1968
8'11"x6'11"x2
5
Three Angels
Andrei Rublyev
Tempura on wood
1410
4'8"x3'9"
6
Voltaire
Jean-Antoine Houdon
Marble
1781
7
Jaguar Devouring a Hare
Antoine-Louis Barye
Bronze
1851
1'4"x3'1"
8
The Peacock Skirt
Aubrey Beardsley
Pen and Ink
1894
9
Untitled Film Still #35
Cindy Sherman
Black-and-white photograph
1979
10"x8"
10
Reclining Figure
Henry Moore
Elm wood
1939
3'1"x2'6"
Table Properties
tbl_Items
ID(int) - Primary Key
Title (varchar - 50)
Owner (varchar - 50)
Canvas (varchar - 20)
Copyright (char - 4)
Sized (varchar - 20)
View 1 Replies
View Related
Mar 8, 2000
Hi,
I am trying to do a DTS Import in SQL Server 7. I am importing from a text file to a SQL Server format. When I run the import to append the data I get the following error:
Error during Transformation 'DirectCopyXform' for row number 1.
Errors encountered so far in this task: 1
TransformCopy "DirectCopyXform'conversion error
Conversion invalid for datatypes on column pair 6(source column 'Col006'
(DBTYPE_STR), destination column 'END_DT'(DBTYPE_DBTIMESTAMP).
Could anyone tell me how to correct this problem?
Any help would be greatly appreciated.
Thanks
Phil
View 2 Replies
View Related
Sep 28, 1998
When I try to import an AS/400 table, I get to the screen where “You can
choose one or more tables to copy.” After selecting one table and clicking
Next, I get a DTS Wizard Error.
Error Description: [StarQuest][StarSQL ODBC Driver][DB2/400] Object
QSYS.QPGMR type *COLLECTION not found.
This ODBC driver is from Microsoft SNA Server version 4.0 and does work with
Microsoft Access.
Can anyone import AS/400 tables?
Thanks
Harley Ainsworth
hainsworth@rayberndtson.com
View 1 Replies
View Related
Aug 27, 2002
Hi,
I've never used DTS before, but would like to employ it to do a rather complicated data import (well complicated in my opinion).
I need to use DTS to import rows from a DBF File into a SQL Table. These DBF files reside on a separate server and can only be operated on once copied to another location so they aren't in an open state. Specifically I want to append the data from the DBF file into a SQL table. That is, a program writes data to a DBF file, and I want to import the new data not yet imported into SQL since the previous import. Another issue is that these DBF files change filenames (table names) every month. In other words, every month a new DBF table is created with the month number in the table name. I would have to import those, but make sure before I do so that all the rows from the previous month's table have been imported and then import the current month. Where I am find myself having the real problem is that in the DBF file, each row doesn't have a primary key I can reference it with. Only way to distinguish one row from another is to reference two columns, a timestamp and account number, those two columns can never be the same in another row. So I am not sure how to keep track of which row to start importing data from the DBF file.
Of course, lastly I'd like to automate this entire process so it happens every minute or two.
Hope that makes sense. Any help or thoughts would be greatly appreciated.
Regards,
-------------------------
Ayaz Asif
Versatile Technologies, Inc.
View 1 Replies
View Related
Sep 3, 2004
Hi All,
I am using bcp utility to import text File data into SQL server table.I import about 50-60 such files. All other files except one file copies less no of rows to the database every time , than it has in the text file. All other files having either less or greater amount of data transfers it properly.I do not know why this happens to only one file.
Colmn delimiter used is | and row delimiters used is .
BCP is being run through a batch file.
Any idea how to solve this?
Thanks & regards
Rohit
View 10 Replies
View Related
Oct 13, 2004
I am trying to centralize event logs with dumpevt to produce csv (comma or tab seperated) files for import via BCP. My problem lies in that it fails to put the CR/LF at the end of the last line.
So I get an "Unexpected EOF encountered" error.
Anyone else familar with this or how I might be able to script an insertion to those files of the CR/LF? Perhaps some way to just script appending a row terminator in the import file?
Any assistance would be GREALTY appreciated.
-Jonah
View 1 Replies
View Related
Dec 29, 2005
I'd like to bcp import a file that sometimes misses the last column/s. There's an EOL character instead. For some reason, bcp wraps around, ignoring the EOL character, and continues reading from the next row of the file. Instead, I'd like to replace the missing columns by null.
I've tried using bcp, bulk insert and the DTS Wizard. So far, I've only been succesfull using the DTS Wizard. I also do some other bcp imports, so I'd like to stick with bcp.
bcp table1 in myFile.csv -SServer1 -T -c -k -t -r
myFile.csv looks like... (replaced tabs by ;)
Col001;Col002;Col003;Col004
Col001;Col002
Col001;Col002;Col003
Col001;Col002;Col003;Col004
etc
are imported as:
Col001;Col002;Col003;Col004
Col001;Col002;Col001;Col002
Col001;Col002;Col003;Col001
etc
Any suggestions?
View 4 Replies
View Related
Feb 6, 2007
Hi There! I have a problem with a DBF file. The problem is that somebody gaves me a data base in DBF format and he uses in SQL Server 2000 and EMS SQL Manager. Well, I have to instal the MDE and SQL Enterprise Manager and when I use the DTS tool to import the data I've got this error:
'Error not Especified'
and I don't know what's happen and how to solve it. Please! Any ideas!
("Sorry about my english")
View 2 Replies
View Related
Aug 6, 2007
Hi
I'm using the BCP facility to import a text file into a database. My problem is, in the table there are 10 fields but my file only contains data for 3 fields
e.g
Table - id,forname,surname,dob,gender,mob_number
File - forname,surname,mob_number
is there a way of only importing into the required fields or do i have to have columns in the order they are in, in the table????
can I use this file??
matt,jones,0775446644
chris,jones,066565465
or do i have to use this???
,matt,jones,,,0775446644
,chris,jones,,,066565465
Edit/Delete Message
View 7 Replies
View Related
Nov 2, 2007
I am trying to import data thru a bcp call to pull data from an access database. I am having trouble accessing the access database. Below is the bcp I tried, along with an openrowset attempt. Neither of them are working. Any help would be greatly appreciated.
bcp select datetime,groupNumber,lineSubgroupNumber,lineNumber ,lineName,inCall,noCallAnswer,
noOutCall,abandonCall,noCallAD,noCallABT,noHelpcal l,noTxcall,noNtcall,totalInNormalTime,
totalOutNormalTime,totalHoldNormalTime,totalAbando nTime,totalLineBusyTime,totalTransTime,
ansCallBin0,ansCallBin1,ansCallBin2,ansCallBin3,an sCallBin4,ansCallBin5,ansCallBin6,
abnCallBin0,abnCallBin1,abnCallBin2,abnCallBin3,ab nCallBin4,abnCallBin5,abnCallBin6
from Line Report in I:200711D1107.MDB -q -UXX -PXX
select datetime,groupNumber,lineSubgroupNumber,lineNumber ,lineName,inCall,noCallAnswer,
noOutCall,abandonCall,noCallAD,noCallABT,noHelpcal l,noTxcall,noNtcall,totalInNormalTime,
totalOutNormalTime,totalHoldNormalTime,totalAbando nTime,totalLineBusyTime,totalTransTime,
ansCallBin0,ansCallBin1,ansCallBin2,ansCallBin3,an sCallBin4,ansCallBin5,ansCallBin6,
abnCallBin0,abnCallBin1,abnCallBin2,abnCallBin3,ab nCallBin4,abnCallBin5,abnCallBin6
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'I:200710D1007.MDB';'XX';'XX', 'Line Report')
View 6 Replies
View Related
Apr 7, 2006
using sql 2005 express for first time
using management studio express to import some tables
tried
In SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data.
does not appear to be avail in express version
Am I missing something here?
Andrew Clark
www.majorleaguecharts.com
View 2 Replies
View Related
May 7, 2006
I had a database in a server, and I recently exported it to a .sql archive in my computer.
Then I went to the phpmyadmin (running on phpMyAdmin 2.6.4-pl2 with MySQL 4.0.25-standard) and... I can't find the "import" function, only the export one... What I'm doing wrong?
View 3 Replies
View Related
Mar 4, 2008
Hello
New to the forum and pretty new to SQL Server. I need to import data from a website written in PHP. The data is a leaderboard for a local poker league. It only contains about 5 columns with about 700 rows of data. I was wondering if there was a script to do this? I merely need to import the data into a table in SQL Server that is set up exactly the same way as the table on the website. Anyone help with this one? Thanks
View 2 Replies
View Related
Jul 20, 2005
Hey guys,I was curious how other people create several 100 SQL objects on anew database. Example: I have each procedure in its own text file (IE100 .sql files), so I just check them out of source control, then runa perl script that just dumps them into one txt file. Then I pastethat mess into Query Analyzer.So to reiterate my question, how do other people get sql objectsinto a database. Obviously I'd do an object copy if they resided insome other database.While my solution works, there is always a better way. Thanks foryour suggestions.- Cpt
View 3 Replies
View Related
Jul 20, 2005
Hi.Please try to bear with this SQL "newbie" here ;)I am trying to figure out how to import the FCC ULS report results into adatabase. I believe what I need is a JOIN statement. To see the datafor yourself, visit http://s91748743.onlinehome.us/wndv619_example.txt(I chose this query because it's near where I live. If you want to runyour own search, the URL ishttp://wireless2.fcc.gov/UlsApp/Uls...archLicense.jsp)(NOTE:The FCC webpage with the query athttp://wireless2.fcc.gov/UlsApp/Uls...archLicense.jsp does justwhat I am trying to do, but I'd like to keep just certain records locallyso that searches are faster and are not dependent on being on a computerwith an internet connection.)I'll try to briefly explain what you are seeing.The .txt file referenced above is a flat text file, pipe-delimited.The very first field is a two-letter code denoting the table type. Someexamples are HD (Header), FR (Frequency), and EM (Emission Type).The second field is a unique entity number.The fourth field contains the call sign (WNDV619).After that, the content varies significantly, based on the first field'stable type.The FCC website lists the column headings for each table type. Forexample, in a HD (Header) table, the first field is the table type, thesecond is the entity number, the fourth field is the call sign, theseventh field is some date, etc. The SQL statements (I believe there aresome syntax errors) to create all of those table types can be found athttp://wireless.fcc.gov/uls/data/do...n/pa_ddef16.sqlFurther specs on the tables can be found at http://wireless.fcc.gov/cgi-bin/wtb-datadump.pl(This is so overwhelming...)What I would like to do is (either in Access if possible--yeah,right--orvia a web-type query in .asp or .html) to be able to click on a callsign, and have a new table appear with choices of table types, then to beable to click on the table type, and have a new table appear with thosechoices, etc.Some entity numbers have more than one call sign. Some call signs havemore than one frequency (as in the example above), etc.Is there an explanation of how to do this already? (What terminologydescribes that which I am trying to accomplish? Linked tables?)Note that with the number of table headers available (that first column,2-letter code) there can be quite a few tables just on one entity numberand/or call sign.Can anybody help?--NOTE: To reply, DELETE the obvious word in my e-mail address you need toDELETE in order to reply.
View 2 Replies
View Related
Aug 1, 2006
i uses sql server 2005 express ,and type command as follow to import data : osql -E -S (local)NetSDK -i InstNwnd.sql (as in Data Access - Bind Data in a ComboBox sample) but got an error :
D:Program FilesMicrosoft Visual Studio 8SDKv2.0SamplesSetup>osql -E -S (lo
cal)NetSDK -i InstNwnd.sql
[SQL Native Client]SQL Network Interfaces: Error Locating Server/Instance
Specified [xFFFFFFFF].
[SQL Native Client]Login timeout expired
[SQL Native Client]An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be caused by
the fact that under the default settings SQL Server does not allow remote connections.
what's is it ? and how i can import data ? thanks
View 4 Replies
View Related
Apr 25, 2007
I grabbed the following .xml and .xsd files from an online tutorial, and tried to import them into SQL Server by using XML Source. I want to be able to import ALL the data; however, the simpleType elements under the root <shiporder> are all missing from the XML source, e.g <orderpersion>. The root element, including any attributes from the root element are also missing...e.g <shiporder orderid="889923"
How can I import these missing fields? The .xml and .xsd files are below.
Any help will be greatly appreciated. Thanks.
.XML and .XSD files below. please note that the website replaces ": s" with
shiporder.xml
----------------
<?xml version="1.0" encoding="ISO-8859-1"?>
<shiporder orderid="889923"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="shiporder.xsd">
<orderperson>John Smith</orderperson>
<shipto>
<name>Ola Nordmann</name>
<address>Langgt 23</address>
<city>4000 Stavanger</city>
<country>Norway</country>
</shipto>
<item>
<title>Empire Burlesque</title>
<note>Special Edition</note>
<quantity>1</quantity>
<price>10.90</price>
</item>
<item>
<title>Hide your heart</title>
<quantity>1</quantity>
<price>9.90</price>
</item>
</shiporder>
----------------
shiporder.xsd...
----------------
<?xml version="1.0" encoding="ISO-8859-1" ?>
<xschema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xsimpleType name="stringtype">
<xs:restriction base="xstring"/>
</xsimpleType>
<xsimpleType name="inttype">
<xs:restriction base="xsositiveInteger"/>
</xsimpleType>
<xsimpleType name="dectype">
<xs:restriction base="xsecimal"/>
</xsimpleType>
<xsimpleType name="orderidtype">
<xs:restriction base="xstring">
<xsattern value="[0-9]{6}"/>
</xs:restriction>
</xsimpleType>
<xs:complexType name="shiptotype">
<xsequence>
<xs:element name="name" type="stringtype"/>
<xs:element name="address" type="stringtype"/>
<xs:element name="city" type="stringtype"/>
<xs:element name="country" type="stringtype"/>
</xsequence>
</xs:complexType>
<xs:complexType name="itemtype">
<xsequence>
<xs:element name="title" type="stringtype"/>
<xs:element name="note" type="stringtype" minOccurs="0"/>
<xs:element name="quantity" type="inttype"/>
<xs:element name="price" type="dectype"/>
</xsequence>
</xs:complexType>
<xs:complexType name="shipordertype">
<xsequence>
<xs:element name="orderperson" type="stringtype"/>
<xs:element name="shipto" type="shiptotype"/>
<xs:element name="item" maxOccurs="unbounded" type="itemtype"/>
</xsequence>
<xs:attribute name="orderid" type="orderidtype" use="required"/>
</xs:complexType>
<xs:element name="shiporder" type="shipordertype"/>
</xschema>
View 3 Replies
View Related
Jan 25, 2008
Could anybody advice me on how to import a text file that does not have consistent coloumn size. Which means there are more than one tables with different specs.
View 5 Replies
View Related
Oct 30, 2007
How can I import a PDF document into an Excel document the same way I import JPEGs? Any information would be greatly appreciated.
View 1 Replies
View Related
Sep 26, 2007
Hi,How to import csv file to sql server databse?Can anybody have the code? Regards Brijesh singh
View 2 Replies
View Related
Dec 28, 2007
I need to import data from a SQL Server (2000) to a SQL Server (2005 Express).I need some data only, and the database structure is different between the 2 databases.How should I do that? What's the best practice?
View 3 Replies
View Related
Nov 18, 2003
Hello All,
I need to import records from one SQL table to another SQL table. Both tables are in the same database. Does anyone know how?
Thank you,
Tina
View 2 Replies
View Related
Dec 18, 2003
Well I seem to be a gomer when trying to understand XML. Could some one please help me? I am trying to write a script or DTS package that will read 4 XML files (Do not call list) compare each phone number to the numbers I have in my DB and if there is a match put the contactID in to another table. Or at the very least get the XML phone numbers into the database. This is what the XML doc looks like
- <list type="full" level="state" val="AL">
- <ac val="205">
<ph val="2025896" />
<ph val="2061994" />
<ph val="2061995" />
<ph val="2062028" />
View 3 Replies
View Related
