Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jeff Perreault
 
Posts: n/a
Default how do I create a data entry edit mask?

I've been tasked with saving excel data as a .csv, then uploading the data
into an ingres database. There are numerous needs for special formatting in
the ingres database, and I'm trying to devise methods to deal with some of
them...

- a numeric field required a blank at the end of it (12345b)
- blank values in the cells that need to be converted either to null or to
-1E38
- 15 character numbers that need to stay as discrete numbers, not go to sci.
not.

Many of these seem like they could be resolved with some edit masks, but I
can't locate any decent coverage of the topic in the online help. Am I not
looking in the right place? Or is there a separate source for documentation
that I should be using?

Jeff
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Data Validation / Cell Entry Steve Jones Excel Discussion (Misc queries) 4 March 23rd 05 03:23 PM
CollegestudentHelp me create an automated data entry program in Ex Desperate College Student Excel Discussion (Misc queries) 2 February 2nd 05 01:21 PM
CollegestudentHelp me create an automated data entry program in Ex College Student Excel Discussion (Misc queries) 1 February 2nd 05 10:27 AM
last data entry in column CHW Excel Worksheet Functions 1 November 4th 04 11:10 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"