473,695 Members | 2,279 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

more and more excel to access....and the inputs are really stupid

We get more and more data done in excel and then they want it imported
into access.
The data is just stupid....value s of 1 to 5 we get a lot of 0's ok
that alright but 1-jan ?
we get colums that are formatted for number and then half way down
they are changed to text.

OR the famous ok now everything in red is ---- and everything in blue
is---------. WTF are these people thinking?

I could go on and on about excel and data collection.

but I have a question has anyone done a lot of testing and thought and
come up with some guidelines on importing so that you do get the data
you want and reformat what you don't get or get incorrectly?
Can you use xml or something to get the colors of cells and their
other attributes so that you can spot the changes made in rows that
cause errors?
Just for exapmle I found the color definitions on rows and colums but
nothing about individual cell formatting.

thanks big time for help, ideas, web pages or books that deal with
this type of thing
Jerry

Apr 12 '06 #1
15 2429
create import specifications - then Access won't try to "guess" what
datatypes you're importing.

Apr 12 '06 #2
Arno R spent a year and a half designing the system!! At every turn he
consulted with an "expert" named B. Quintal. The "expert" kept telling him
to export his data (hundreds of thousands of records) one field at a time.
"It works so it is correct way to do it" the expert kept insisting. At every
turn Arno R asked, "WTF now Bob?"
"sparks" <js******@swbel l.net> wrote in message
news:7l******** *************** *********@4ax.c om...
We get more and more data done in excel and then they want it imported
into access.
The data is just stupid....value s of 1 to 5 we get a lot of 0's ok
that alright but 1-jan ?
we get colums that are formatted for number and then half way down
they are changed to text.

OR the famous ok now everything in red is ---- and everything in blue
is---------. WTF are these people thinking?

I could go on and on about excel and data collection.

but I have a question has anyone done a lot of testing and thought and
come up with some guidelines on importing so that you do get the data
you want and reformat what you don't get or get incorrectly?
Can you use xml or something to get the colors of cells and their
other attributes so that you can spot the changes made in rows that
cause errors?
Just for exapmle I found the color definitions on rows and colums but
nothing about individual cell formatting.

thanks big time for help, ideas, web pages or books that deal with
this type of thing
Jerry

Apr 12 '06 #3
Such an eloquent put down, but what has it to do with the question?

John... Visio MVP

"PC D" <fa***@email.co m> wrote in message
news:Wf******** *********@newsr ead3.news.atl.e arthlink.net...
Arno R spent a year and a half designing the system!! At every turn he
consulted with an "expert" named B. Quintal. The "expert" kept telling him
to export his data (hundreds of thousands of records) one field at a time.
"It works so it is correct way to do it" the expert kept insisting. At
every turn Arno R asked, "WTF now Bob?"



Apr 12 '06 #4
sparks wrote:
We get more and more data done in excel and then they want it imported
into access.
The data is just stupid....value s of 1 to 5 we get a lot of 0's ok
that alright but 1-jan ?
we get colums that are formatted for number and then half way down
they are changed to text.

OR the famous ok now everything in red is ---- and everything in blue
is---------. WTF are these people thinking?

I could go on and on about excel and data collection.

but I have a question has anyone done a lot of testing and thought and
come up with some guidelines on importing so that you do get the data
you want and reformat what you don't get or get incorrectly?
Can you use xml or something to get the colors of cells and their
other attributes so that you can spot the changes made in rows that
cause errors?
Just for exapmle I found the color definitions on rows and colums but
nothing about individual cell formatting.

thanks big time for help, ideas, web pages or books that deal with
this type of thing
Jerry


Jerry, I realize that this doesn't help answer your questions, but
grooming data is always costly. It's time consuming, tedious and error
prone. Generally it is very much preferred to validate the data at the
point of entry. Any chance you could get them to enter the data
directly into an Access application for that purpose, then transfer the
data from Access to Access? That sort of thing is generally easy to
cost justify.

My 2 cents worth,

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.
Apr 12 '06 #5
"John Marshall, MVP" <la******@stone henge.ca> wrote in
news:g7******** ************@ma gma.ca:
Such an eloquent put down, but what has it to do with the
question?

John... Visio MVP

"PC D" <fa***@email.co m> wrote in message
news:Wf******** *********@newsr ead3.news.atl.e arthlink.net...
Arno R spent a year and a half designing the system!! At
every turn he consulted with an "expert" named B. Quintal.
The "expert" kept telling him to export his data (hundreds of
thousands of records) one field at a time. "It works so it is
correct way to do it" the expert kept insisting. At every
turn Arno R asked, "WTF now Bob?"

Like PCD himself, it's totally irrelevant to the question.
And like PCD's answers to questions it's wrong.

But I will credit PCD for self-improvement. At least it's not a
wrong answer.
--
Bob Quintal

PA is y I've altered my email address.
Apr 13 '06 #6
Never mind John, let PC D be what he is, a pile of sh*.

I am afraid he forgot to take his pills again....
He is only mad because Bob called him a Pretty Crappy Developer in another thread.

Arno R
"John Marshall, MVP" <la******@stone henge.ca> schreef in bericht news:g7******** ************@ma gma.ca...
Such an eloquent put down, but what has it to do with the question?

John... Visio MVP

"PC D" <fa***@email.co m> wrote in message
news:Wf******** *********@newsr ead3.news.atl.e arthlink.net...
Arno R spent a year and a half designing the system!! At every turn he
consulted with an "expert" named B. Quintal. The "expert" kept telling him
to export his data (hundreds of thousands of records) one field at a time.
"It works so it is correct way to do it" the expert kept insisting. At
every turn Arno R asked, "WTF now Bob?"




Apr 13 '06 #7
Well I understand the 3 points you have made and the ARE valid.
BUT these people know only one thing.
Excel is fast easy and I have it up all the time.
I just enter some data, move it where I want and if I need to move or
change anything I just do it.
I DONT HAVE TO MESS WITH YOU PEOPLE
when I want to add variables, or change the input of 1 to 5 to 1 to 99
I DO IT.
I CAN show my people that RED is something they need to look out for.
AND MOST OF ALL I CAN set it up the way I WANT and change it any time
I WANT and don't have to mess with your department.

That is the responses we are seeing more and more.
They keep asking why are you here?
You want to build a database and charge us $$$ then we have to wait
while you make modifications that cost us $$$.
I can do all this and it doesn't cost my department a dime.

This is what we are seeing more and more and there is NO WAY that they
will listen to anything we have to say.
We have one person that says I HATE ACCESS...now foxpro thats a
database.
ALL YOU DO is charge us for stuff and we have to bend over backwards
to get it to work the way we want.

( most of the time when we do a database it is give to them for
testing) 3-4 weeks later we here the data has been entered...NOW make
these changes, add these new variables and WTF do I have to go thru
every record and enter what you didn't do...MAN I HATE ACCESS

sorry about the long rant but we are a small and hated department. NO
MATTER what we do we are wrong and no matter how good the database is
there are people that JUST DONT WANT TO USE IT. for reasons above.

But after all is said and done here is the data.
WTF do you mean your department can't import it into sas for analysis
because of errors...ITS ALL RIGHT THERE

you f#$%ing guys suck...
=============== =============== =============== ====
you can't win so we were trying to figure out a way to scan the excel
files for the stupid things they do and be able to convert it to
access tables and give them a database with their excel data so they
can continue on the right way.
(most of these data collections will go on for several years on and
off.)
We get the stuff at some point and are trying to get things back to
access.

AND SORRY FOR THE RANT I just get tired of these people and their
ways.

Jerry
On Wed, 12 Apr 2006 21:35:05 GMT, Randy Harris <pl****@send.no .spam>
wrote:
sparks wrote:
We get more and more data done in excel and then they want it imported
into access.
The data is just stupid....value s of 1 to 5 we get a lot of 0's ok
that alright but 1-jan ?
we get colums that are formatted for number and then half way down
they are changed to text.

OR the famous ok now everything in red is ---- and everything in blue
is---------. WTF are these people thinking?

I could go on and on about excel and data collection.

but I have a question has anyone done a lot of testing and thought and
come up with some guidelines on importing so that you do get the data
you want and reformat what you don't get or get incorrectly?
Can you use xml or something to get the colors of cells and their
other attributes so that you can spot the changes made in rows that
cause errors?
Just for exapmle I found the color definitions on rows and colums but
nothing about individual cell formatting.

thanks big time for help, ideas, web pages or books that deal with
this type of thing
Jerry


Jerry, I realize that this doesn't help answer your questions, but
grooming data is always costly. It's time consuming, tedious and error
prone. Generally it is very much preferred to validate the data at the
point of entry. Any chance you could get them to enter the data
directly into an Access application for that purpose, then transfer the
data from Access to Access? That sort of thing is generally easy to
cost justify.

My 2 cents worth,


Apr 13 '06 #8
Oops, almost forgot ---

Arno R never consulted with John Marshall on this project because John
Marshall never makes an y contributions to the newsgroup.

"John Marshall, MVP" <la******@stone henge.ca> wrote in message
news:g7******** ************@ma gma.ca...
Such an eloquent put down, but what has it to do with the question?

John... Visio MVP

"PC D" <fa***@email.co m> wrote in message
news:Wf******** *********@newsr ead3.news.atl.e arthlink.net...
Arno R spent a year and a half designing the system!! At every turn he
consulted with an "expert" named B. Quintal. The "expert" kept telling
him to export his data (hundreds of thousands of records) one field at a
time. "It works so it is correct way to do it" the expert kept insisting.
At every turn Arno R asked, "WTF now Bob?"


Apr 13 '06 #9
Meet Mr. B. Quintal!!!

His routine for importing hundreds of thousands of records one field at a
time just ended right before he responded!!
"Bob Quintal" <rq******@sympa tico.ca> wrote in message
news:Xn******** **************@ 207.35.177.135. ..
"John Marshall, MVP" <la******@stone henge.ca> wrote in
news:g7******** ************@ma gma.ca:
Such an eloquent put down, but what has it to do with the
question?

John... Visio MVP

"PC D" <fa***@email.co m> wrote in message
news:Wf******** *********@newsr ead3.news.atl.e arthlink.net...
Arno R spent a year and a half designing the system!! At
every turn he consulted with an "expert" named B. Quintal.
The "expert" kept telling him to export his data (hundreds of
thousands of records) one field at a time. "It works so it is
correct way to do it" the expert kept insisting. At every
turn Arno R asked, "WTF now Bob?"

Like PCD himself, it's totally irrelevant to the question.
And like PCD's answers to questions it's wrong.

But I will credit PCD for self-improvement. At least it's not a
wrong answer.
--
Bob Quintal

PA is y I've altered my email address.

Apr 13 '06 #10

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

Similar topics

116
7506
by: Mike MacSween | last post by:
S**t for brains strikes again! Why did I do that? When I met the clients and at some point they vaguely asked whether eventually would it be possible to have some people who could read the data and some who couldn't but that it wasn't important right now. And I said, 'sure, we can do that later'. So now I've developed an app without any thought to security and am trying to apply it afterwards. Doh!, doh! and triple doh!
13
3244
by: Arno R | last post by:
Hi all, I will have to handle a lot of really 'nice' data in a LOT of Excel sheets. It is all about music files (Billboard top 100) I am afraid there really is a sheet for every year ... (Don't know this for sure yet...) I definitely need to get this data in Access and get it normalized. (sigh ....) The data is so 'nice' for the Import- and TransferSpreadsheet-wizard that the 'wizard' really chokes on it ;-) Either the data is not...
0
2835
by: Jack | last post by:
Windows 2K Pro Access/Excel 2003 Hi there, I have a large number of password protected Excel Workbooks. The files are protected by code that runs when the workbook opens. The code asks the user to key in a password into an input box, the password is compared to a a partciular cell on a hidden (xlVeryHidden) sheet and if it matches the Workbooks opens. I have not used the usual Excel password protection as I need to provide for several...
8
788
by: Sam | last post by:
Hi All, I posted this message few days ago. No one has answered so far. I just would like to know if it is possible to do or not. Even if you can not tell me how to do this, maybe you know which library I need to use in order to access excel information from a VB.NET code. For example, I would be interested by knowing how to access a simple cell value in an excel file from a vb.net code. Here is the mail I sent last week, but as I...
5
4099
by: billelev | last post by:
Hi there. I need to perform a number of financial calculations within a database I am creating. Rather than writing my own functions, I figured it would be worthwhile to use the functions that already exist within excel. I have found sample code on the web for calling an excel function (being new to Access I tend to borrow bits and pieces from anywhere and everywhere): Function fXLCoupDayBS(dtmSettlement As Date, dtmMaturity As Date,...
18
4401
by: gonzlobo | last post by:
No, I don't want to destroy them (funny how the word 'decimate' has changed definition over the years) :). We have a data acquisition program that saves its output to Excel's ..xls format. Unfortunately, the programmer was too stupid to write files the average user can read. I'd like some advice on how to go about: 1. Reading a large Excel file and chop it into many Excel files (with only 65535 lines per file)
7
7063
by: ddecoste | last post by:
I have a need to add a visual representation to some data in Access. I need to draw a matix of squares inside another square. I have all the data that I need in a record in Access. The data changes according to what the user inputs. I know that Access does not allow you to draw on forms so I decided to put the output in an Excel file for the user but I am having trouble drawing the rectange from Access. Here is my simple code so far: ...
1
2243
by: Vae07 | last post by:
Ok so here is a brief summary of my problem. I need a pop up form that submits input text box information to a pocket excel workbook upon a command botton click. Text box inputs are checked for validity upon individual text box exit (don't have a problem with this part). All this could be done with Excel VBA easily, but pocket excel doesn't have VBA/Macro support. In as much, I have been trying to create a VB2005 application that I can load...
7
4657
by: TinyTom | last post by:
I really need help with this code. I have made a pretty complicated subform that automatically updates filter criteria based off of inputs in various fields within the search form. What I need to do is design a command button that will kick out the information that is stored in the subform to an excel document. Ideally I would like to use the DoCmd.OutputTo function so that the user could choose their output type, but right now I'll take...
0
8635
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8574
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,...
0
8990
jinu1996
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...
1
8850
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,...
0
7664
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, 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...
1
6493
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4580
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3007
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
2
2276
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.