Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Import dataImport data
Previous
 
Next
New Post
2/18/2009 9:15 AM
 

I need to impor a xls file in to a table in database (not user import) wat modul i need to use?

 
New Post
2/18/2009 1:11 PM
 

Florin wrote
 

I need to impor a xls file in to a table in database (not user import) wat modul i need to use?

Most modules are designed to import data into specific tables of thier own, or tables they are designed to deal with.  it's kind of alot to ask a module to import into a random table as there is so much that changes from table to table.   Data types etc. 

How do you plan to display the data once it's imported?  Are you attempting to import into a user defined table?

 


Josh Martin

 
New Post
2/19/2009 4:39 AM
 

i have a xls file. i need to make a new table in database. i need to import all data from xls in table. i display the data with Reports.

SELECT
dbo.Nume,
dbo.Prenume,
dbo.CNP,
dbo.Polita,
dbo.DataScadenta

FROM dbo.scadente_web
INNER JOIN
dbo.Users
ON
dbo.scadente_web.Nume = dbo.Users.FirstName AND dbo.scadente_web.Prenume = dbo.Users.LastName AND dbo.Users.userid=@UserID

 
New Post
2/19/2009 4:49 AM
 

and wha'ts your problem now? first create the table, second import data, I suggest to use SQL Server Management Studio or MS Access, if you have direct acces to the database..


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
2/20/2009 4:04 PM
 

Hi Florin,

I think you might need to install the Module Data Exchanger. It helps to export data of DNN2 module to XML file and import data from XML file to DNN2 module.

Optimus
 

 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Import dataImport data


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out