473,396 Members | 2,021 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Excel functionnality in Acces

I am currently using excel to manage a small database. The problem is
my database is getting big and I need more then the 65000 lines excel
can have.

I have considered access but it lacks some important built-in features
from excel. For exemple:

- Easily Add multiples similar entry with incremental numbers or lets
say the same line 40 times.
Ok lets say I have somes book numbered 1 - 500. Currently I don't know
how to add this easily in acces.
- Add colors easily: Only way it seems possible is by code. Though it
could be a good idea.
- Display Conveniency
MS Excel seems to have a better front end then Access.
Maybe I just don't know how to use acces in this case I would
appreciate a help as to where I could find info to do what I want
Else is there a software that could fill my needs for such a database.

In fact what I need is something usefull to enter data and to display
it. The database format itself is not really important.
Thx in advance for your help
Nov 13 '05 #1
0 1160

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Geert-Pieter Hof | last post by:
Hello, My VB 6.0 application read and writes data from and to a MS Excel workbook, using the Microsoft.Jet.OLEDB.4.0 provider. Now I want to protect the Excel workbook with a password, but I...
5
by: Bram Stolk | last post by:
pyHello, Google helped me find a nice package to interface python with MS Excel. "win32all", or sometimes called by the name "pywin32". http://starship.python.net/crew/mhammond/ However,...
2
by: bill | last post by:
Hi All, When I send html content with Excel MIME type, the page break style sheet {page-break-before: always} doesn't work at Excel spreadsheet. Any idea to convert html page break style sheet to...
2
by: zino | last post by:
I have a file that is created in Excel and saved as an htm file. (if I open the file through Excel it open as Excel file, if I click on the file name it open in internet explorer). I need to...
3
by: Rich Pu | last post by:
Hi Guys, Hope you can help I am trying to interact with excel and I am having a problem with pastespecial values I am trying excelobj.activesheet.pastespecial paste:=xlvalues it keeps...
2
by: Ronny Sigo | last post by:
Hello all, I am trying to automate Excel via vba(access). If I try to write values in the second sheet (InkNieuweleden)of the workbook the program puts these values always in the first sheet...
1
by: @ndy | last post by:
Hey fella's, I have a table with an Id and LineId in Access. I have these Id's also in an Excel sheet. Is it possible to find the Id's in the Excel sheet corresponding from Acces and then adapt...
2
by: Robert | last post by:
Hi I'm doing program in Visual C++ 6 How to export whole MS Acces table to MS Excel in Visual Basic 6 there is a command 'DoCmd.TransferSpreadsheet' (OLE automation) but I don't know how to use...
7
by: Wernerh | last post by:
Hi all, Have created a vb application that interacts with Excel for report purposes. Base application and excel file is on host pc on network. I require the clients to access the excel workbook for...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
agi2029
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,...

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.