Excel File into Module

[nlsmike]

Just wondering if there is way to insert a table into a module easily. I really would like to put in an excel table into the module. Any help would be appreciated. Thanks Mike

[Brian]

You can add a new template module and format your table and contents manaully.

[nlsmike]

I have looked around for instructions on how to use the template modules but I can not seem to find it.

[Brian]

Just go to Admin CP => vBa CMPS => Add Module => Template Module, and fill in the blanks there.

[nlsmike]

I have got that far but I am confused on how this is going to help me put in an excel file.

[Brian]

Sorry if I wasn't clear enough before, but you're not going to be able to use an Excel file as a module. You would need to format the table manually using HTML code instead.

[nlsmike]

Ahhh Ok thats what I wanted to know. Thanks for that info.

[nlsmike]

Alright I have this all worked out now but my page is not coming up properly. Can anyone help? here is the page: http://nolimitsportsline.com/index.php?pageid=AEAST
that big space above "tester" module is not supposed to be there.

[Brian]

Looks like there's quite a few errors in the coding for that page, one (or more) of which is probably causing the problem.

http://validator.w3.org/check?uri=ht...e&group=0&ss=1

[nlsmike]

Thats the code I got from excel after I created the page. I just need to create an easy way to import information into a table like that one. Its a pain to do that every week code wise when you get the info from someone else. Ahhh well looks like I am going to have to do it the long way from now on

[bobster65]

Originally Posted by nlsmike

Thats the code I got from excel after I created the page. I just need to create an easy way to import information into a table like that one. Its a pain to do that every week code wise when you get the info from someone else. Ahhh well looks like I am going to have to do it the long way from now on

export the data from the excel spreadsheet in a comma delimited file, then import that data into a table(s) in a database on your server (would be easiest to just use the vB DB and add a table(s)..) then write some simple code to pull the data from the DB Table(s) to form the HTML Table layout that you are looking to display. Its a pretty simple basic project for a coder to start off with. Then all you have to do to update is export from excel and import into the DB. You can even create a script that all you have to do from the ACP is click on upload excel file and the system does it for you (of course, this is more advanced lol) ...

Anyway dude.. it is a rather simple process that most people would tend to make a Mountain out of a Mole hill over.

[nlsmike]

Yeah and I think the way you described it makes it sound hard. I wish I was not so new with this stuff. Do not know very much about it. Thanks for taking the time to help though.

[bobster65]

Originally Posted by nlsmike

Yeah and I think the way you described it makes it sound hard. I wish I was not so new with this stuff. Do not know very much about it. Thanks for taking the time to help though.

Its not hard tho... thats the thing.. it may sound hard, but its not. Hard is doing it manually lol .. If you get burned out doing the manual thing, a system can be built for you pretty easily.

[nlsmike]

Originally Posted by bobster65

export the data from the excel spreadsheet in a comma delimited file, then import that data into a table(s) in a database on your server (would be easiest to just use the vB DB and add a table(s)..) then write some simple code to pull the data from the DB Table(s) to form the HTML Table layout that you are looking to display. Its a pretty simple basic project for a coder to start off with. Then all you have to do to update is export from excel and import into the DB. You can even create a script that all you have to do from the ACP is click on upload excel file and the system does it for you (of course, this is more advanced lol) ...

Anyway dude.. it is a rather simple process that most people would tend to make a Mountain out of a Mole hill over.

Been awhile but I am back into getting this together soon. Anyway you can help me with this?

[garcia]

I just wanna say excel is so powerful, i think some good resource and suggestion can be found online.