Importing Data From Excel To Database - Unexpected Unrecoverable Error

Jan 1, 2015

I want to import data from excel (1.2 million rows in 1 sheet) to SQL Server 2014 database. I am using SQL Server 2014 Import Export Data functionality and getting this error - unexpected unrecoverable error.

3 buttons beside it - abort, retry, ignore - all having the import export to close.

But I could successfully import data from excel file having less rows (150000 rows)

View 1 Replies


ADVERTISEMENT

Error While Importing Data From Excel

May 20, 2008



Hi,

My excel sheet consists of mix data types, numbers and characters but when we use excel source in data flow it onlys recognises characters and displays number as NULL. After going through this link
http://www.***s-blog.com/archives/2004/06/03/external-data-mixed-data-types/

The above link displays *** in url as it pronounces as deeks, so u need to replace "ee" as "ic" and u can see the blog.

I modified my excel source as Select * from[Excel 8.0;HDR=YES;IMEX=1;Database=C:Test.xls;].[Sheet1$]; It displays all the columns and values properly when previewed but when we execute the package it gives error as

Error: 0xC0202009 at Test, Connection manager "Excel Connection Manager": SSIS Error Code DTS_E_OLEDBERROR.
An OLE DB error has occurred. Error code: 0x80040E21.



Please help

Thanks

View 4 Replies View Related

Need Help Importing Data From Excel To My SQL Database

Jan 16, 2008

Hey guys,I am trying to import data from an Excel spreadsheet into my SQLdatabase. I am running SQL 2005.I following Microsoft's instructions for creating a linked server, andit appeared to work. However when I run this query:SELECT * INTO test FROM OPENQUERY(EFORMS,'SELECT * FROM [Form Tracker Baseline$]')I get the following error:The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server"EFORMS" reported an error. The provider did not give any informationabout the error.Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider"Microsoft.Jet.OLEDB.4.0" for linked server "EFORMS".Test is the table that will receive the imported data. Eforms is thename of my linked server, and Form Tracker Baseline is the worksheetname.The error sounds like it can not locate my spreadsheet. Any ideas whyI am getting this message? Is there an easier way to do this import?Thanks,

View 4 Replies View Related

Error Importing From Excel To Odbc Sql Database

Dec 17, 2007

Got an error of

Error during Transformation 'DirectCopyXform' for Row number 813. Errors encountered so far in this task: 1.
TransformCopy 'DirectCopyXform' conversion error: Destination does not allow NULL on column pair 1 (source column 'Customer' (DBTYPE_R8), destination column 'Customer' (DBTYPE_STR))

What does that mean?

I have an excel file named Customer List with fields such as Customer, Name, City.
I want to import it into a syspro table called SyproCompanyF.ArCustomer.

View 4 Replies View Related

Error When Importing Data From Excel File

Aug 22, 2006

Hi!

This is what i'm doing:

IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srv.srvid !=

0 AND srv.srvname = N'ExcelSource')

EXEC master.dbo.sp_dropserver @server=N'ExcelSource', @droplogins='droplogins';

-
EXEC master.dbo.sp_addlinkedserver
@server = 'ExcelSource',
@srvproduct = 'Excel',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@datasrc = @Chemin,
@provstr = 'Excel 8.0';


EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname = 'ExcelSource',
@useself = false,
@locallogin = NULL,
@rmtuser ='ADMIN',
@rmtpassword = NULL;

set @NomServ = 'ExcelSource';

This create a linkedServer to read my ExcelFile.

Then i'm doing this:

EXEC ('Insert into Elements (No_element, Nom_elem, Desc_elem, Code_grpe_classe, Tps_elem, Code_sgrpe, Code_produit)
Select No_element, Nom_elem, Desc_elem, Code_grpe_classe, Tps_elem, Code_sgrpe, Code_produit
from ' + @NomServ + '...[Elements$];')

This is where i got an error. The error is:
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ExcelSource" does not contain the table "Elements$". The table either does not exist or the current user does not have permissions on that table.

I can't figure out what i'm missing. I've add permissions for EVERYONE on the file and on the folder just to be sure and i still have the same error. How can i check if the table [Elements$] exist ?

View 3 Replies View Related

Importing Data From Excel To SQL SERVER Database

Aug 23, 2006

Hello all:

I have gone through most of the question posed by people, about importing data from EXCEL sheet to some table using SQL server database. I have a slight variation of this problem.

My excel file contains some information apart from the normal data.
Lets say some 5-6 lines always gives me some info about the data, like its purpose, client info, date etc...
After this INFO my actually data start, which I want to load into table.

I have found some wizard for the same, "EMS SQL MANAGER 2005", which supports most of the file formats, and load data into the database.

But we are planning to not use this tool, instead everything should be done using TSQL.

If somebody can please gives me some idea how this problem can be tackle, it would be a great help. We won't be using any Third party tools, like scripting etc...

We want to stick with just TSQL for this problem.

Thanks a bunch,
sabegh

View 1 Replies View Related

Importing Data From Excel Sheets Into SQL Server Database

Feb 15, 2006

Hi,
Would like some help on how do I go about coverting an Excel File with columns of info into my SQL Server Database. The excel file will be uploaded from a user from my web application. I completely have no idea on where to start so any form of help is much appreciated thanks.

View 3 Replies View Related

Issue In Importing Data From Excel Into Database Table

Mar 7, 2008



Hi

I am facing issue while loading data from excel into Sql database table.
The format of spreadsheet is like

Date -
Name - A B C
Section Marks
X1 10 10 10
X2 20 30 10

X3

I need to load this data into table with columns

Date
Name
Section
Marks

Please share your thoughts on how to load this kind of data into table.

Thanks
Anshu

View 1 Replies View Related

Importing An Excel File And Save Data Into A Database In My Web Account

Aug 30, 2007

Hi everyone, sorry if this message is not supposed to be posted here.
I'm learning asp.net , and would like to know how I can insert data from a excel file into a database on my web account. Pretty much insert/update information in the database using excel file or a access file. 
Thanks a lot in advance

View 3 Replies View Related

Problems Importing Data From Excel (numbers Stored As Text Error)

May 21, 2008

i have an excel sheet
in it there is a column that holds values of item numbers
some of these values are preceeded with zeros E.G "00123" (with out the ")
when i view the data in excel i get this little green corner whice states (when pressed) that these values are numbers stoerd as text.
no inside the excel sheet i have no problem with that
but when i try to import the excel sheet into ssis using an excel source task
all these values are imported as nulls!!!

i am lost
i tried converting the format of these cells to numbers but then i loose the leading zeros
what i done temporarly to solve this problem is to accept excel's suggestion and turn these values into numbers
i then import them and convert them to strings in ssis and then ad dthe zeros.
now althouge this works, this isnt realy a solution.
i canot manualy correct each excel file each time i get a new copy
and in the future i will not have the luxuery of having fixed lenght values (so i wont be able to know how many zeroe i"d need to add)

there must be a better way
please help
thanks in advance
Daniel

View 3 Replies View Related

Error Importing Data From Oracle Database To An SQL Database

Oct 11, 2005

Hi!

View 36 Replies View Related

TSQL + VBA Excel 2003 - Importing Data From MS Excel 2003 To SQL SERVER 2000 Using Multi - Batch Processing

Sep 11, 2007

Hi,
I need to import an SQL string from MS Excel 2003 to SQL SERVER 2000.
The string I need to import is composed by 5 different several blocks and looks like:



Code Snippet

CommandLine01 = "USE mydb"
CommandLine02 = "SELECT Block ..."
CommandLine03 = "GO
ALTER TABLE Block...
GO"
CommandLine04 = "UPDATE Block..."
CommandLine05 = "SELECT Block..."

The detail of the SQL string is at:
http://forums.microsoft.com/msdn/showpost.aspx?postid=2093921&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1



I am trying to implement OJ's suggestion:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2117223&SiteID=1
to use multi - batch processing to import the string to SQL SERVER, something like:




Code Snippet
Dim SqlCnt, cmd1, cmd2, cmd3
'set the properties and open a connection

cmd1="use my_db"
cmd2="create table mytb"
cmd3="insert into mytb"

SqlCnt.execute cmd1
SqlCnt.Execute cmd2
SqlCnt.Execute cmd3

Below is the code (just partial) I have, and I need help to complete it.
Thanks in advance,
Aldo.




Code Snippet
Function TestConnection()
Dim ConnectionString As New ADODB.Connection
Dim RecordSet As New ADODB.RecordSet

ConnectionString = "Driver={SQL Server};Server=myServer;Database=myDBName;Uid=UserName;Pwd=Password"
ConnectionString.Open

CmdLine01 = " USE " & myDB
CmdLine02 = " SELECT ACCOUNTS.FULLNAME FROM ACCOUNTS" ...

CmdLine03 = "GO
ALTER TABLE Block...
GO"

CmdLine04 = "UPDATE Block..."
CmdLine05 = "SELECT Block..."

RecordSet.Open CmdLine01, ConnectionString
RecordSet.Open CmdLine02, ConnectionString

ConnectionString.Execute CmdLine01
ConnectionString.Execute CmdLine02

'Retrieve Field titles
For ColNr = 1 To RecordSet.Fields.Count
ActiveSheet.Cells(1, ColNr).Value = RecordSet.Fields(ColNr - 1).Name
Next

ActiveSheet.Cells(2, 1).CopyFromRecordset RecordSet

'Close ADO objects
RecordSet.Close
ConnectionString.Close
Set RecordSet = Nothing
Set ConnectionString = Nothing

End Function






View 7 Replies View Related

Error Importing Excel File

Mar 7, 2006

When ever importing a excel file or flat file, I get an Unhandled exception error and the event log reads a .Netframework error ID 1000.

Checking the database I was importing into, I find that the table was created with the columns, but no data within the columns.

The import wizards report 509 row copyed before crashing with the Handle error, where a dialog box appears allowing debug or close.

Can anyone help?

I include the logged errors.

Event Log

.NET Runtime 2.0 Error
Event ID: 1000

Faulting application dtswizard.exe, version 9.0.1399.0, stamp 434f5e2a, faulting module dtspipeline.dll, version 2005.90.1399.0, stamp 434f5dbc, debug? 0, fault address 0x0004ba38.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

0000: 41 00 70 00 70 00 6c 00 A.p.p.l.
0008: 69 00 63 00 61 00 74 00 i.c.a.t.
0010: 69 00 6f 00 6e 00 20 00 i.o.n. .
0018: 46 00 61 00 69 00 6c 00 F.a.i.l.
0020: 75 00 72 00 65 00 20 00 u.r.e. .
0028: 20 00 64 00 74 00 73 00 .d.t.s.
0030: 77 00 69 00 7a 00 61 00 w.i.z.a.
0038: 72 00 64 00 2e 00 65 00 r.d...e.
0040: 78 00 65 00 20 00 39 00 x.e. .9.
0048: 2e 00 30 00 2e 00 31 00 ..0...1.
0050: 33 00 39 00 39 00 2e 00 3.9.9...
0058: 30 00 20 00 34 00 33 00 0. .4.3.
0060: 34 00 66 00 35 00 65 00 4.f.5.e.
0068: 32 00 61 00 20 00 69 00 2.a. .i.
0070: 6e 00 20 00 64 00 74 00 n. .d.t.
0078: 73 00 70 00 69 00 70 00 s.p.i.p.
0080: 65 00 6c 00 69 00 6e 00 e.l.i.n.
0088: 65 00 2e 00 64 00 6c 00 e...d.l.
0090: 6c 00 20 00 32 00 30 00 l. .2.0.
0098: 30 00 35 00 2e 00 39 00 0.5...9.
00a0: 30 00 2e 00 31 00 33 00 0...1.3.
00a8: 39 00 39 00 2e 00 30 00 9.9...0.
00b0: 20 00 34 00 33 00 34 00 .4.3.4.
00b8: 66 00 35 00 64 00 62 00 f.5.d.b.
00c0: 63 00 20 00 66 00 44 00 c. .f.D.
00c8: 65 00 62 00 75 00 67 00 e.b.u.g.
00d0: 20 00 30 00 20 00 61 00 .0. .a.
00d8: 74 00 20 00 6f 00 66 00 t. .o.f.
00e0: 66 00 73 00 65 00 74 00 f.s.e.t.
00e8: 20 00 30 00 30 00 30 00 .0.0.0.
00f0: 34 00 62 00 61 00 33 00 4.b.a.3.
00f8: 38 00 0d 00 0a 00 8.....



Debug Log

Unhandled exception at 0x2357ba38 in DTSWizard.exe: 0xC000001D: Illegal Instruction.

View 4 Replies View Related

Importing Data From Excel Into Sql

May 23, 2008

Hi i have an excel spreadsheet in which I want to take the data and put them in a table, the table and excel speadsheet have the same unique-ID, what i need to do is retrieve the extra fields of the excel spreadsheet and match them up with the table. Is this possible, if so how?

View 6 Replies View Related

Importing Excel Data

Feb 3, 2006

Here is the scenario: I have an excel spreadsheet that contains 182 columns, and I need to move this data into a semi-normalized database for reporting. The SQL Server database schema has 11 tables. Some of the tables are going to use identity columns for their PK, other tables are using a value that comes from this spreadsheet for their PK values.Anyway, I have never done a DTS package of any significance before, and know I most likely need to write some VBScript to handle sticking data into the proper data tables, etc.I am just hoping someone can point me at a good resource, give me an alternative means of doing this (this is a process that will need to happen whenever a new Excel spreadsheet is dropped into a folder or on a schedule, either one). I would love to write some C# code to handle these things, but a DTS package would probably be the best, I just don't know where to start.Thanks,

View 2 Replies View Related

Importing Data From Excel

Apr 17, 2006

I have an excel document that I need to import into a table. The format of the Excel spreadsheet has three columns:

|First Name | Last Name | Zip code|

This data is not normalized. I want to convert the data in the spreadsheet to foreign key values for two existing tables.

The table I'm importing to will contain records with a many-to-many relationship.

For example,

|John|Smith|77079

imports as:

|1|1|

Where "Smith" is the first record in the 'rep' table and "77079" is the first record in the 'zip' table.

How can I bring the data in and then convert the de-normalized data into ID values from my existing tables?

I have thousands of records that I need to do this for and want to automate the process.

Thanks for any help.
Regards,
-D-

View 1 Replies View Related

Importing Data From Excel To SQL

Apr 14, 2008

I am using SQL 2005 the developer edition and need to import a couple thousand records while I try and create a web tool that will filter the data.

I know unltimately I will need to create some sort of application to move the data over. But I am not going to waste my time do that unless I am successful on the web site side.

What is an easy way to import the data. I tried the import wizzard multiple times and have recieved an error...multiple times.

View 6 Replies View Related

Importing Data From Excel

Jun 10, 2007

Hi,



In SQL 2005, is there a way to autmotatically import data from excel into an existing table. So far, I can only do this into a new table. Any help is appreciated.



View 5 Replies View Related

Importing Excel To Database Problem

May 6, 2008

Hi,

I need to import data from excel to sql database. I have an excel that has a column called dept_name that is a string.
In the database I have a table called tb_depts with the following columns:
dept_id int, identity
dept_name nvarchar (200)

In addition I have another table called tb_extUsers with the following columns:
user_id int, identity
user_name nvarchar (200)
dept_id int

I need to import the excel into the table tb_extUsers however my problem is that the value in excel is the name of the department and not the department id and the column in tb_extUsers requires the id.
How can i insert the correct dept_id into tb_extUsers ?

Can someone please assist me?

Thanks






Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

View 4 Replies View Related

Importing Excel File Into Database

Sep 4, 2007

Hi, I am very new to ssis, I am trying to set up a package that I can set to run every hour or so, what it will do is look for all excel files in a certain folder and import them into a table on an sql server.

I managed to get it working but my problem is that my data is survey answers and some columns contain a comment.
I get these files on a weekly basis and some weeks the length of the longest comment makes ssis want to use a different data type for the comment column (sometimes it wants DT_NTEXT, other times it wants DT_WSTR).
as this column is filled out by a human I guess aposrtophies and other characters may affext this as well.

when I made the data flow task, I used the wizard on a file which contained about 8 weeks worth of data. when I use 1 weeks worth of data where the comment length is very low, the task gives a validation error saying the metadata is out of sync. if I go back and set the data type for that column to DT_WSTR and rerun the task, it works but then when it tries to process a different weeks worth of data it will fail again

here is an example of an error I get when it thinks the data type is wrong.
[Source - 'raw data$' [1]] Error: The output column "Question ID50# (Verbatim)" (439) on the error output has properties that do not match the properties of its corresponding data source column.

I played around with the data types for a while and managed to get it to process the first file and then try to process the secondfile, in the second file it got around the validation but then got this error:
[Source - 'raw data$' [1]] Error: Failed to retrieve long data for column "Question ID3# (Verbatim)".

is there a way to make it recalculate the data types by itself for each excel file?


I am stuck trying to figure this one out.
sorry if I havent provided enough information, I am not sure which direction to head with this

View 4 Replies View Related

Error While While Importing Excel File Into SQL2005

Nov 6, 2007



I am using the import tool to import a small excell file into SQL.
I am getting the following error

Error 0xc00470fe: Data Flow TAsk: The product level is insufficient for componene "source - Current_customer$" (1)

The file name I am importing is Current_customer, which contains 4 fields
Id
last
first
zip

View 3 Replies View Related

Importing Data From Excel Or Access

Feb 27, 2007

Hello,
 
I am trying to import a table from Access and/or Excel.  I have attempted with both programs.  I get errors possibly due to some bad data over the years.  Is it possible to tell SQL Server to import a table and discard any errors? or is there a way to scrub the data before importing to make sure all possible causes of errors are corrected or addressed?

View 3 Replies View Related

Importing Data From Excel To SQL Server

Sep 14, 2004

I have a Excel 2000 column which looks like this:

Column A
23456
234-67
2-56
354899865

When I create a DTS package to import this column, only the values without a hyphen get imported correctly..and a null value will show for the numbers that have a hyphen in it.

I've set my datatype to varchar, float, nvarchar, text, etc in SQL Server 2000...but nothing seems to work. I have also changed the datatype in my excel spreadsheet to text, general, etc.

I've tried so many combinations, I forget which ones I've tested...Anybody have an idea what I should try ?

Thank you

View 3 Replies View Related

Importing Data From An Excel File

Nov 13, 2007

Hi all,
I am trying to export data from an excel file to SQL Server database for reporting. Unfortunately I get the following errors.


[OLE DB Destination [54]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".

Could some one bail me out of this bug.

Regards,

Ronaldlee








View 1 Replies View Related

Importing Data From Excel Sheet

Oct 19, 2007

i using the select command

select * from [excel sheet name$];

i also using open file dialoug to specify the excel book this book should be pass to the select command at run time
as a parameter

so plz help me with suitable example

View 1 Replies View Related

Data Format Issue While Importing Data From Excel To SQL

Jul 17, 2007

hi



when i m importing data from excel to Sql using DTS the column which has text content was not imported as same in excel sheet. whereas a special character is appearing in between the lines. the text field contains multiple lines but the conetent is imported in single line .

ex:









ARIZONA
ALABAMA
STATE


but i m getting imported

as :
ARIZONA ALABAMA STATE

How to Format a single column while importing?



Regards

Raj

View 1 Replies View Related

DTS Error: Importing From Excel File To SQL Server 2000

Nov 30, 2007

 Data for Source Column 15 'Notes' is too large for the specified buffer size. How do I get around this, I can see some of the notes entries are beyond 255 chars so I changed the destination datatype to textI have never seen this error when importing before. What do I do? 

View 1 Replies View Related

Unexpected Error From External Database Driver (MS Access Linked Table)

Oct 19, 2006

OS: Windows XP (SP2)
App: MS Access 2003 (SP2)
DB: MS SQL 2000 (SP4, 2040)

User is using MS Access linked table to query database (using ODBC). User can open the query in MS Access. However when the user goes to export the data to MS Excel format, the user receives the error message:

"Unexpected Error from External Database Driver (22)."

A trace on the db, reveals that the user process is attempting to log in to the server as 'Admin'. However, when the query with the linked table is first opened, the user is prompted for username/password (non Windows authentication).

Any ideas? I googled and found some stuff, but nothing directly related and most of what I found was supposedly fixed with SP1.

Any help appreciated. I am not an Access guru.

Regards,

hmscott

View 1 Replies View Related

ASP .NET--Problem With Importing Data From Excel To SQL Server..

Feb 21, 2008

Is there any way to import the excel data to SqlServer 2000 without using OleDb Connection in the code...??
Help Me with this??
Thanks in advance..

View 5 Replies View Related

Importing Data From Excel File Into SQL Server

Apr 9, 2000

Can anybody please give an example of how to import data from an Excel file to SQL Server in a VB Application using DTS.

I am particularly facing problems creating the connection for the Excel file. An example for that would be aprticularly helpful.

Thanks in adv,
Rahul.

View 1 Replies View Related

Importing Excel Data Into MS SQL Problems-Any Ideas?

Apr 29, 2004

My issue involves importing data from excel into MS SQL properly.

Currently I am using MSSQL Standard Edition, ASP Pages and VBScript together to allow users of my site to upload excel sheets with a specific column header arrangement and the subsequent data below.

The issue I am having is that even with the data formatted (General, text, or any other ways I have tried), MS SQL still does not recognize most of the data in the cells. Mainly data in the first column, the rest of the columns seem not to have as much of an issue.

Problem being is that the data consists of numbers and letters, more specifically part numbers. These part numbers can be a wide range of combinations of say 12HJ78UY-001 or NT78E64AA. If it is pure numbers such as 0983465, then it imports perfect, but if there are numbers and letters mixed then MS SQL places a <NULL> in the field instead.

I thought it was the VBScript, so I took one of the excel files and manually imported it into its own table into MS SQL. The exact same problem occurred.

I exported the data in the excel sheet to a text file (tab delimited), then imported it into a new table into MS SQL, it worked perfect. No data problems whatsoever.

I have even converted the data to a text file, copied it all, then performed a “Paste Special” (which I know my users will never do) on a new fresh Excel sheet, and MS SQL still cannot read the information properly, I get the <NULL>.

Currently everything I have is automated and I need to keep it that way, but I cannot seem to find an automated solution to convert xls to txt or make MS SQL read these excel sheets properly.

Any ideas? Thank you very much in advance if you have the answer.

View 12 Replies View Related

Problem In Importing Data From Excel To Sql Server

Apr 19, 2007

I have excel file that has field named Purpose. Its max length is 400 character. I import this file to sql server database table. And also i change the purpose field in sql server database table with nvarchar 400. But when i run this job, it gave me error message:

Error at source for row number 1215. Errors encountereed so far in this task: 1.
Data for source column 18 ('Purpose') is too large for the specified buffer size.

What should i do so that i still can import the data from excel to sql server database?

Thanks for your help.

View 1 Replies View Related

Problem In Importing Data From Excel To Sql2005

Sep 20, 2006

Hi
I have to import data from a number of excel files to corresponding tables in SQL 2005. The excel files are created using excel 4.0. I have created an excel connection manager and provided it with the path of the excel sheet.Next i have added an excel source from the toolbox to the dataflow. I have set the connection manger, data access mode, and the name of the excel sheet (the wizard detects the sheet correctly) in the dialog window i get when i double click the excel source. Every thing goes fine till here. Now when i select the 'columns' in this dialog window or the preview button, i get this error

TITLE: Microsoft Visual Studio------------------------------Error at Data Flow Task [Excel Source [1]]: An OLE DB error has occurred. Error code: 0x80004005.Error at Data Flow Task [Excel Source [1]]: Opening a rowset for "test4$" failed. Check that the object exists in the database.------------------------------ADDITIONAL INFORMATION:Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap)------------------------------

Any ideas about why is this happening???
Umer

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved