November 18, 2014 at 2:04 am
Hi Friends,
I m already created a table and i wanna to insert values in that more than five hundred row ,that values are stored in Excel files,Here i ve the doubt is it possible to insert values from excel sheet?
i ve current data base of ms sql 2000 ,if it is possible means tell me how to insert values using query?
ex:
---
create table test
(
item_code int,
item_name varchar(50),
bill_qty float,
bil_date datetime
)
in that excel file also had the same column name names
Thanks
Rocky
November 18, 2014 at 7:27 am
If you're using SQL 2000 and pulling from excel, I'd recommend looking at the DTS Import/Export Wizard. Here's a couple of links to look at as a reference
http://support.microsoft.com/kb/321686
http://dbatasks.blogspot.com/2011/09/create-dts-package-to-import-excel.html
November 18, 2014 at 7:40 am
For what it is worth, you should consider using a numeric datatype instead of float. It appears this is dealing with money and float is not an exact numeric datatype.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
November 18, 2014 at 9:02 am
Sean Lange (11/18/2014)
For what it is worth, you should consider using a numeric datatype instead of float. It appears this is dealing with money and float is not an exact numeric datatype.
or even int, for bill-qty (unless you can bill for fractional items)
Gerald Britton, Pluralsight courses
November 18, 2014 at 2:23 pm
g.britton (11/18/2014)
Sean Lange (11/18/2014)
For what it is worth, you should consider using a numeric datatype instead of float. It appears this is dealing with money and float is not an exact numeric datatype.or even int, for bill-qty (unless you can bill for fractional items)
True enough. I was guessing that maybe that column was the total amount billed but the column is certainly ambiguous enough that it doesn't provide much insight. 😉
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply