"Make ODBC connection at your local machine with proper connectivity with database,
now open your excel file and select export, choose odbc and select your created odbc name and you can send directly in your dabase,
this is no matter which…"
A Social Network for PeopleSoft Professionals
Stephen's Discussions
how to export data from spreadsheet to datatable?
Started this discussion. Last reply by Pankaj Kumar Jan 10, 2011. 2 Replies 0 Likes
Hi experts,i want to know what's the best way to export data from spreadsheet to datatable? maybe,…Continue
Tags: datatable, to, spreadsheet
Gifts Received
Stephen has not received any gifts yet
Stephen's Page
Latest Activity
PSoftPros replied to Stephen's discussion how to export data from spreadsheet to datatable?
"The best way is to save the spreadsheet as a comma delimited file. Then you can use SQR, Application Engine, or even Oracle SQL Loader to load the data to a table.
I hope that helps.
Derek"
Stephen posted a discussion
how to export data from spreadsheet to datatable?
Hi experts,i want to know what's the best way to export data from spreadsheet to datatable? maybe, any way that can export data from spreadsheet to datatable.Thanks for any answers.See More
Stephen replied to Chuck's discussion Uploading and Reading Excel File
"Sir, how about try to use Spire.XLS for .NET, which is a professional .NET excel application"
Profile Information
- How many years of PeopleSoft experience do you have?
- Less than 1 Year
- What PeopleSoft applications does your company use?
- Human Capital
- What is your expertise?
- Other
Latest PeopleSoft Jobs
PeopleSoft Functional Analyst
Youngstown , OHPeopleSoft Finanical HR/Payroll 8.9
Calabasas , CAPeopleSoft Administrator
Brooklyn , NYPeopleSoft DBA(Oracle)
Lisle , ILPeopleSoft Senior P/A(Financials)
Bridgewater , NJPeopleSoft Books
Events
© 2012 Created by PSoftPros.
