How to import a file - Microsoft Access / VBA

Roy

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

Sep 10 '07 #1

Subscribe Post Reply

1965

Salad

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

Sep 10 '07 #2

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.

Sep 10 '07 #3

Salad

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.

Sep 10 '07 #4

Similar topics

Recursive import within packages

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:

Python

dynamic 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...

Python

Import Semantics, or 'What's the scope of an import?', and classattribute instantiation

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...

Python

Hey, get this! [was: import from database]

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...

Python

circular import problem

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

Python

File Import Wizard

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...

.NET Framework

Why I need to declare import as global in function

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...

Python

import confused by contents of working directory

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...

Python

import in threads: crashes & strange exceptions on dual core machines

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...

Python

How can I import functions from another python file

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...

Python

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

VBA Class Basics

by: NeoPa | last post by:

Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...

Microsoft Access / VBA

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...

Microsoft Access / VBA

Finding a record, and then saving a new record after the record has been amended.

by: nia12 | last post by:

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA