Hi All,
I have an A2003 application .Recently we had a request to import data
from IDL files and create some reports.
Since I have no idea to do that using Access,I used Excel to import
data and then imported these excel sheets into Access tables.
Is there a way to directly import IDL files into Access using any
method or VBA?
Thanks,
Roy 3 1985
Roy wrote:
Hi All,
I have an A2003 application .Recently we had a request to import data
from IDL files and create some reports.
Since I have no idea to do that using Access,I used Excel to import
data and then imported these excel sheets into Access tables.
Is there a way to directly import IDL files into Access using any
method or VBA?
How do you import it into Excel?
Thanks,
Roy
On Sep 10, 4:49 pm, Salad <o...@vinegar.comwrote:
Roy wrote:
Hi All,
I have an A2003 application .Recently we had a request to import data
from IDL files and create some reports.
Since I have no idea to do that using Access,I used Excel to import
data and then imported these excel sheets into Access tables.
Is there a way to directly import IDL files into Access using any
method or VBA?
How do you import it into Excel?
Thanks,
Roy- Hide quoted text -
- Show quoted text -
I do this manually.Using the Import Data functionality on the Excel
Menu.
Roy wrote:
On Sep 10, 4:49 pm, Salad <o...@vinegar.comwrote:
>>Roy wrote:
>>>Hi All, I have an A2003 application .Recently we had a request to import data from IDL files and create some reports. Since I have no idea to do that using Access,I used Excel to import data and then imported these excel sheets into Access tables.
>>>Is there a way to directly import IDL files into Access using any method or VBA?
How do you import it into Excel?
>>>Thanks, Roy- Hide quoted text -
- Show quoted text -
I do this manually.Using the Import Data functionality on the Excel
Menu.
Can you use Open statement in Access to do the import?
Ex:
Type Record ' Define user-defined type.
ID As Integer
Name As String * 20
End Type
Dim MyRecord As Record ' Declare variable.
Open "TESTFILE" For Random As #1 Len = Len(MyRecord)
' Close before reopening in another mode.
Close #1
See LineInput, Get, Write, etc in help. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Stian Sřiland |
last post by:
all examples performed with:
Python 2.3+ (#2, Aug 10 2003, 11:09:33)
on linux2
(2, 3, 0, 'final', 1)
This is a recursive import:
|
by: bry |
last post by:
Hi,
I'm trying to do a dynamic import of a file that has no problems with it, that
is to say I can import it normally, my sys.path is set to the right folder etc.
but my dynamic import code is not...
|
by: Andrew James |
last post by:
All,
I'm having some trouble with understanding python's importing behaviour
in my application. I'm using psyco to optimise part of my code, but I'm
not sure whether it inherits throughout the...
|
by: Steve Holden |
last post by:
This is even stranger: it makes it if I import the module a second time:
import dbimp as dbimp
import sys
if __name__ == "__main__":
dbimp.install()
#k = sys.modules.keys()
#k.sort()
#for...
|
by: Learning Python |
last post by:
An example in the book I didn't understood well
two modules files recursively import/from each other
in recur1.py,we have:
x=1
import recur2
y=1
|
by: David Berry |
last post by:
Hi All. I'm looking for any help or sample code that can show me how to make a file import wizard in ASP.NET (VB preferred) like the one that MS Access uses. I'm working on a web site where the...
|
by: didier.doussaud |
last post by:
I have a stange side effect in my project :
in my project I need to write "gobal" to use global symbol :
....
import math
....
def f() :
global math # necessary ?????? else next line...
|
by: Jon |
last post by:
It appears that (windows) python searches in the current working
directory before looking in the local site-packages directory, or that
'.' comes first in sys.path? The problem arises when I made...
|
by: robert |
last post by:
I get python crashes and (in better cases) strange Python exceptions when (in most cases) importing and using cookielib lazy on demand in a thread.
It is mainly with cookielib, but remember the...
|
by: yinglcs |
last post by:
Hi,
i have 2 python files in *different directory* , how can I import
python functions from 1 python file to another?
i get this error:
import task
ImportError: No module named task/
Thank...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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...
|
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...
|
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,...
| |