Hello everyone,
I am a newbie at MS Access and I need help!!!
I am importing an excel file using Import functionality in MS Access, all the fields are required but there are instances in the excel sheet wherein some of the fields are not populated. The fields that are being imported are: Full Name, first name, last name, initial (optional), userID and email address. How do i inform the users that the following records were not imported because the following values are not available.
How do I display the list of users which do not have the required values available?
I am importing the file to a temporary table. Is there an easy way of validating data from the temp table and then returning error messages to the user? Where can this be coded?
Because after validating the file that was imported, I have to check if this the main repository is empty. If it is empty, copy the data to the main repository table. If it is not empty, then compare the temp table with the existing table and then return a message what has been changed. If the user selects, YES then changes are copied to the main table.
thanks,
rhiz
2 2563
...I am importing an excel file using Import functionality in MS Access, all the fields are required but there are instances in the excel sheet wherein some of the fields are not populated. The fields that are being imported are: Full Name, first name, last name, initial (optional), userID and email address. How do i inform the users that the following records were not imported because the following values are not available..
Hi Irheeza. Before delving into validation of missing rows, you need to check whether the import into Access is correctly transferring the original Excel data. Because Excel cells can contain numbers, text, or mixed alpha numeric values the import routines in Access can become confused over the right type of the data, which is guessed from the contents of the first row of data in the excel sheet.
As an example, if the first field of the first row imported has a number in it the Access import routine will create a numeric field in that position of the import table. If a later row in Excel has a text value in that cell instead of a number the Access import will stumble, because it can't put the text value into the numeric field. This will result in a missing field value in your Access table (and possibly an entry for that row in an error table, depending on how you are importing or pasting the data).
It could be that it is not the users that are at fault over missing data, but the Access import itself. Let's eliminate that first, so could you check the imported data against the Excel original and let us know, please?
Regards
Stewart
thanks, stewart, i will do that.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Mark Lees |
last post by:
Just installed 2003 and the help file sucks because it tries to
connect to Microsoft Online Help which takes too long. When I run
Access and I'm not connected to the internet, it seems to connect to
the locally stored help files. How can I turn off the online help and
just access the locally stored help files?
|
by: Wayne Aprato |
last post by:
I have a client who is running several Access 97 databases that I have
written for them. They are about to upgrade to Access 2003. Is the
default file format of Access 2003 still Access 2000 the same as it
was in Access 2002?
I am running Access 2002 at the moment. Is there any reason for
testing purposes etc, for me to purchase Access 2003 if I am going to
recompile the Access 97 mdb files into Access 2000 format mde files
which...
|
by: Wayne Aprato |
last post by:
I have several Access 2003 mde databases. When I try to open them in
Access 2002 I get the following error:
"The Visual Basic for Applications project in the database is
corrupt."
Interestingly I can open the mdb files of the same 2003 databases in
Access 2002 without problems. To my understanding the file formats of
2002 and 2003 are the same and this problem shouldn't exist. And why
is it only the mde files that are giving the...
|
by: Avalanche |
last post by:
Greetings all.
I'm building a database (Access 2003) of applicants. Included in this
database I would like to include the PDF applications for individuals
in the database, accessable from a form or table within Access (not a
hyperlink). Any ideas on how to make this work?
Thanks...
|
by: jamesbeswick |
last post by:
I've been using Access since version 97 and I've migrated to 2003. I've
noticed a substantial number of strange ActiveX/OLE and code corruption
problems when writing databases. The only solution I've found is to
create a new database and import all the objects from the corrupted
file.
Has anyone else found a solution to this annoying problem? I cannot
find anything useful on Microsoft's website and I haven't seen any
posts about the...
| |
by: John Overton |
last post by:
I have a new requirement to Import and Export Excel tables into and out of Access 2003. The Excel tables are located on a remote server but I know the path to the Excel Files.
Can you please help me with the Access VBA code I need to perform these Importing and Exporting tasks??
Sincerely,
John Overton
|
by: Neelesh2007 |
last post by:
I have designed software with VB6.0 as frontEnd & access-2003 as backend. For running action queries & for importing text files to my database i am using DoCmd object for which i have add reference to Miscrosoft Access 11.0 object library. In my PC it works fine as i have installed Access 2003 in my PC but in other PC's where Access -2003 is not installed it is giving error "Can not create ActiveX object" and other errors also. It works fine if...
|
by: Access |
last post by:
Anyone else experiencing corruption problems using Access 2003 to
edit .adp files? I've been experiencing corruption problems with a
particular database. I've tried copying all the objects into a new
file, but it didn't help.
Here is an example of the problem, yesterday I added a new field to my
SQL table. To put it on the form I copied an existing text field and
converted that field from text to combo box. Quicker because I'm
using...
|
by: HistoricVFP |
last post by:
Hello,
I’ve been given the task of importing .dbf files from a very old version of Visual FoxPro (version 2.1) into Access (2003). When I import the data straight to Access it errors with:
External table is not in the expected format. (Error 3274)
I’ve tried the following but it did not work:
“To import data from a FoxPro database, use the Microsoft Visual FoxPro ODBC driver. To do so, follow these steps:
1. Click Start, and then...
|
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 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...
| |