By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

How to import a file

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.