473,325 Members | 2,870 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,325 software developers and data experts.

How to have a mass upload feature in my MSAccess Database

1
I am more than a novice in MS Access. I am creating my First database for my company that will be used internally for data input into a mastertable. There will be over 300 pieces of information to be put in at one time and I wanted to know if their is a way to mass upload/input into the database as opposed to typing in each individual piece of information into the form.

I can upload the database if that will make it easier to understand the information.
May 26 '11 #1
2 2051
beacon
579 512MB
Hi Sayo,

Welcome to Bytes!

Is the information that you want to upload/input in another database? If not, is it in a spreadsheet at least? There's a very simple way to import the data if it's already in a database or a spreadsheet, although you may want to format the spreadsheet or resave it with a different file extension prior to importing.

I mostly use Access 2003, so please forgive me if I'm off slightly on the location of the functions. That being said, if you go to the Office button (the color round button in the top, left-hand corner), there should be an option for Get External Data. From this menu you should be able to import your data from another database or spreadsheet.

If you're going to import from a spreadsheet, you may want to remove any unnecessary formatting or rows that contain headers as these may not transfer well during the import process. I've found that .csv files (.csv = comma separated value - a spreadsheet that contains values that are separated by commas) works well, but I won't get into that in case you're not familiar with it. You can always search the topic to learn more about it if you want.

Once you've chosen to import, you'll likely be prompted to identify how you want the data imported. Just choose the options that work best for you for your situation and the data should be loaded. Unless you're importing from another Access database, you'll probably have to import tables/spreadsheets one item at a time, depending on how many of each you have.

For the second part of your question, if you have individuals that are using a previous version of Access, in your case 2000, they won't be able to see any of the features that are new to Access 2007, such as the split form feature. The individuals would likely either need to upgrade to 2007 or you would need to develop a solution that is backward compatible with 2000.

Hope this helps and good luck,
beacon
May 26 '11 #2
NeoPa
32,556 Expert Mod 16PB
There are many ways to upload data into an Access table, but what to use depends heavily on what data and where it is available. As you haven't provided any of this information I cannot help further at this time.
May 26 '11 #3

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

Similar topics

4
by: wahodi | last post by:
Dear all I want to provide a function using asp for the users to search for their excel files in their PCs in IE and then upload to my database. Is it possible Best regards wahodi
1
by: ABC | last post by:
Web.Config Editing have no intellisense feature on VC# web site project under VS IDE 2005. How can I turn it on?
0
by: Siegfried Heintze | last post by:
This program works fine on my desktop when I grant full control of the MSAccess database to everyone. However, when I put it on my hosting service with no impersonation, I now get this error (see...
1
by: Siegfried Heintze | last post by:
I have some cygwin cron jobs running under the Administrator account populating a MSAccess database that is simultaneously being queried by IIS/ASP.NET/C#. If I manually use windows explorer to...
0
by: priyanka s | last post by:
hello guys, 1) I have to take data from server and store in my msaccess database and also display the current changes in a text file I am working with dialog based application.And one more thing If...
17
by: kartheek | last post by:
hi friends, can any one out here help me by giving me the code to connect to an MSACCESS database using javascript.
0
by: Shyam Barnwal | last post by:
Hi All, I am working on winamp general purpose pluggin "gen_whatsplaying " project downloaded from the site www.schaffrath.net I compiled and build the project successfully using platform SDK...
4
by: PierreD | last post by:
I have this data acquisition program, writing to an Access database every minute. The link between the two is through an ODBC User data source. The database gets bigger and bigger. I would like...
1
by: anakraj | last post by:
Dear sir,madam I am developing a one website. in that site to create a login form . backend is access database. i din't no how to connect the access database. in our ftp server. in local...
8
by: azegurb | last post by:
Hi i have taken news script with image upload feature it works fine. it show image and its being getting smalled thumbnail at the right side but when i added news without image instead of image...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.