470,612 Members | 2,387 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,612 developers. It's quick & easy.

How to import a file

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

Similar topics

reply views Thread by Stian SÝiland | last post: by
6 posts views Thread by bry | last post: by
5 posts views Thread by Steve Holden | last post: by
1 post views Thread by Learning Python | last post: by
2 posts views Thread by David Berry | last post: by
16 posts views Thread by didier.doussaud | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.