- For individual users
- Instant access to solutions
- Ask your tech questions
- Start your 30-day Free Trial
Main TopicsBrowse All Topics
working on a Notes database...one of its function is...that user will be able to import the Excel files.
Following is the code i am using to import the Excel files into Lotus Notes database...i found this on the web and alter it a bit for my needs.
so far...as far as my testing goes it is working fine. However i am not sure that how come i am getting the correct Date values. Please allow me to explain further.
Excel file that i am using for testing...in it couple of columns have Date values (i have set the format for all the cells in these columns as Date). And then using the code below...importing the Excel file in the Lotus Notes Db. And along with other values...getting the correct Date values from the Excel file. Even when i change the cell format of the Date e.g. (13-Dec-07 or September 19, 2008 or 11/26/08) i got the correct Date values in the Lotus Notes Db. i think what i am saying is that how the code below knows what is the month and what is the day from different cell formats that i have in the Excel file. The one thing that i found that even if i have different cell formats e.g. (13-Dec-07 or September 19, 2008 or 11/26/08) in the formula bar of the Excel it always shows as mm/dd/yyyy (is this is due to the control panel -> regional setting? and is this is why even with different cell formats i am getting the correct date values?)
what i like to make sure is this that when user will use the Lotus Notes Db and import their generated Excel files, how to ensure that the code below import the correct Date values
from the user Excel files. (like what if user does not format the column and its cells as Date, what if in the user Excel file the Date value stored as text or something). i do not know how?...may be some kind of check in the following code to make sure that the Date Values from Excel files will be imported correctly.
Following are the lines from the code below...where i am reading it from the Excel and storing it in the Date fields on the form.
cur_doc.Datefield1 = rs.Fields(8).value
cur_doc.Datefield2 = rs.Fields(9).value
Sorry if it seems like a long story but i like to give as much related info as i can. Need your help.
This question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
900+ topic areas (and counting)
It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul.
We love the accolades. We love to be seen as the digital white knight who fixed the server, the computer, the email, and anything else that life depends on.
We love it so much, we sometimes make horrible decisions. Sometimes, we work "FOR FREE."
SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispersed nature of the blog posts that deal with some of these issues. This article will help SCCM OSD newbies with some of these issues.
For our deployments, we always install MDT 2008 on our SCCM server and select Configure ConfigMgr Integration from the MDT area on the start menu. This gives us:
Get full access to the help you need.
30 Day free trial. Register in 60 seconds.
Bringing you the latest in technology
|Congressman Proposes Bill to Ban...||11/28/12|
|Death to Internet Anonymity: Google...||11/27/12|
|TEDx San Luis Obispo||11/20/12|
|SharePoint 2010 No-Code Solutions...||11/19/12|
|Keeping Your Passwords And Your Win...||11/15/12|
|Fun and Games with Hackers: How to...||11/15/12|
Listen while you work
Because of our active community of experts, on average new questions receive their first comment in under 30 minutes.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30 Day free trial. Register in 60 seconds.
30-Day Free Trial
Answer for Membership
"With the help of Experts Exchange -- I have been able to meet my deadlines and produce effective products"
"I just today started my third contract assignment which I attribute to the skills I am learning from other experts."
"It's my sole resource as I'm kind of an MS Access loner at my company. It's like having colleagues available when I run out of my own steam."
Leew has been an expert here since 1997 and is a master at Windows 2000 and XP, hard drives/storage and Small Business Server.
lrmoore has been an expert here since 2000 and is a six-time Microsoft MVP with over 18 years experience in the networking industry.
angeliii has been an expert here since 2000 and is a Microsoft MVP for his work with MS SQL Server and Development
"The experts approach solutions with patience and innovative ideas, and ultimately I have my problem solved."
"Most every situation is already posted and answered, a quick search usually gives a solution. EE is truly a bargain."
"9 out of 10 times Experts Exchange has the accepted solution or an open discussion of the potential solutions to the problem."
At Experts Exchange, we treat each question as unique and deserving of an answer.
As one of the most enduring technology resources, our community knows the importance of helping each individual with their problem, no matter how complex or how simple. We're here to collaborate with you.