?
Solved

Import excel file

Posted on 2006-11-14
3
Medium Priority
?
457 Views
Last Modified: 2008-01-09
I have a excel file im trying to import with fields cpmt_id , fk_emp_id , cpmt_date, cpmt_amount, cpmt_created_by,

I go to the import wirzard and select first row does not contain headers
map the source and destination go to edit and tell it to ignore the first row
then run it and get this error

Warning 0x80047076: Data Flow Task: The output column "F1" (15) on output "Excel Source Output" (9) and component "Source - Sheet1$" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
 (SQL Server Import and Export Wizard)
 
Can anyone help

Thanks
0
Comment
Question by:fsuedu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 29

Expert Comment

by:Gautham Janardhan
ID: 17939040
after selecting the source and destination

go to transformation and map only the wanted columns
0
 
LVL 11

Accepted Solution

by:
MacNuttin earned 2000 total points
ID: 17940888
Try run this from SQL Query Analyser:

INSERT INTO YourTable
Select cpmt_id , fk_emp_id , cpmt_date, cpmt_amount, cpmt_created_by from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="C:\Path\YourExcelFile.xls";Extended properties=Excel 8.0')...Sheet1$
0
 
LVL 11

Expert Comment

by:MacNuttin
ID: 17940908
You will need a header row in excel file
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question