473,882 Members | 1,549 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Front end for Excel so that I can use excel as database

7 New Member
Dear Experts,

I need to use a any front end for my excel(as database here)
That front end has to allow macros to run and data to transport to and from the front end.

request you, could you please suggest any of such(HTML ,Xcelcious).

Eagerly waiting for your reply ..thanks in advance

Jan 11 '13 #1
9 22153
5,501 Recognized Expert Moderator Expert

What you ask is counter intuitive and, imho, counter productive. No spread sheet program will ever work well as the backend for a database.

Instead, I would advise you to reconsider moving your entire project over to one of the Database programs, such as MS Access.
Jan 11 '13 #2
32,584 Recognized Expert Moderator MVP
I have no idea what causes you to have this requirement, Basav. It's certainly unusual and counter-intuitive as Z states. I would suggest you only consider this if you have thought through the whole idea thoroughly. We can help with that if you like.

That said, while Access can handle Excel as a BE quite effectively, that does not include the ability to run BE macros easily. You may need to consider some Application Automation code to handle that. That is assuming you even go ahead with what is certainly an awkward approach.
Jan 11 '13 #3
7 New Member
Dear Z and Neopa,

Thank you for your prompt reply and suggestion.

Here, All that i want is, just need to conceal the excel.
I do not want show the Excel file to end user.

We an achieve this by using Xcelcious, but unfortunately it wont support macros in that other than few Excel functions..

And, this will not be going online it ll be in stand alone system only...
Jan 12 '13 #4
5,501 Recognized Expert Moderator Expert

I've taken a few moments to review Xcelcious and its functionality.

What you are asking us to do is to either design and build a entire program or do extensive research into the web and other resources to find you a suitable program.

What you fail to understand is that Bytes is mainly a bunch of like minded, unpaid volunteers, not a software design company nor a research group.
Jan 12 '13 #5
7 New Member
Dear Z,

I'm a kid in Excel development.
I'm just looking for an experts advice or suggestion to get done my work.

Who am i here to urge do extensive research and why they have to do at all?

Just checking if they know any such to suggest me.

For instance Xcelcious is supporting excel functions.
Checking for similar sort of software which supports macros too..there are ample of experts in Bytes from all over the word, probably any one of them would have used or know about such..

That's all i'm looking for.

Basavaraj CG
Jan 12 '13 #6
32,584 Recognized Expert Moderator MVP
We're mainly Access experts actually. Many of us are Excel experts too. Hoping for experience elsewhere is not pointless, but it is certainly not what we offer (though we're normally happy to offer anything we do have experience with).

In this case, I see no reason why you would need to complicate the situation even as far as to store your data in Excel. You can store it in Access with the same level of obscurity from the users (probably more in fact), so, from what you've said in your answer to my question, everything in Access would be your best bet.
Jan 12 '13 #7
7 New Member
Thank you NeoPa for your suggestion.
Jan 13 '13 #8
12,516 Recognized Expert Moderator MVP
I want to echo everyone's suggestion that you not use Excel as a backend. But yes, you can write code to do what you want. I don't know of any programs that already do what you want because most people would use Access instead of Excel. I don't understand why you need to "hide" Excel.
Jan 13 '13 #9
2,322 Recognized Expert Moderator Top Contributor
Often times you will find that if you explain not only WHAT you want to achieve but also WHY you want to achieve it, you will get far better replies. In almost all questions, time taken to formulate a proper, precise detailed questions is returned hundredfold.

While Excel and Access might look quite similar on "first" approach, they are radically different. You will likely spend 10 times the hours trying to develop a front-end against excel then it takes to do it against Access or any other database.
Jan 13 '13 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Mike Turco | last post by:
What is the difference between creating relationships in the front-end vs. the back-end database? I was trying to create a relationship in a database front-end and noticed that I could not check the referential integrity box. What gives? Continuing on with that line of thinking, I understand what do the relationships do for you in a database, but what do they do physically to the tables? Thanks,
by: jfathman | last post by:
Hello, We are considering a project that requires implementing a database (Windows PC based) that would be shared by a small number of users. The database would store events output by our networking device, and any of the users could generate reports based on the stored event data. This would be for small, low-cost systems, not large enterprise systems with big commercial databases and dedicated servers.
by: Bob W | last post by:
All, What I want to do is parse some data using vb.net/asp.net from a database to a file in excel format. Now I know I can parse it into a ..csv file, but is there a way to parse it to a .xls file (some .net libary or documented format). Thanks, Bob
by: Tim Frawley | last post by:
I created a .NET Com Class object for use in ASP reports to export database results directly to Excel. I have it all working just find but I cannot get the Excel process to go away after the job is done. I am using the following .NET code in my Com Class object: <ComClass(DIF2XLS.ClassId, DIF2XLS.InterfaceId, DIF2XLS.EventsId)> _ Public Class DIF2XLS #Region "COM GUIDs"
by: jack | last post by:
Hi. My project requires to upload the excel file and populate it into the database. By doing so it should also check whether the excel file selected is in the right format. for example if the file contains the Name , Address and Age fields. Then the Name , Address column should accept all characters while the age column should accept only numbers
by: mohaaron | last post by:
Has anyone else tried to save a GridView as a excel file and then use ado.net to read the excel sheet back into a database table? I'm having a terrible time trying to make this work. The normal method of doing this using OleDb and a connection string like the following doesn't work on a Excel file that has been created from a GridView. Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + file + "; Extended Properties=\"Excel...
by: Dutchy | last post by:
Hi All, I have a spreadsheet that is basically a list of events with start and end date, country, location and business unit organising the event. Instead of copying each and every event into a excel calendar (for the format I could imagine the calendar to look like the example on: http://www.vertex42.com/ExcelTemplates/excel-calendar-template.html) I would like to automatically parse the spreadsheet data and publish it in the...
by: =?Utf-8?B?QXNobGV5VA==?= | last post by:
Inside : Private Sub _xlApp_WorkbookBeforeClose(ByRef Cancel As Boolean) Handles _xlApp.WorkbookBeforeClose I have Try Dim QuoteActivity As New QuoteSheetActivityForm() QuoteActivity.BringToFront()
by: PandaKel | last post by:
Hi, I would need to save a whole excel file into 1 field in SQL2005. i have created a field with varbinary(max) in a database table. can someone please help to advise how the excel can be translated into binary? and save into that field? after that i will need a link to let user click to retrieve back the file as excel. any help? thanks a lot.
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.