importing into Access from a .exp file

[Simplycongy]

extra code

Ooops..


forgot two its of extra code that you need to avoid this little error....

In the RunExcel module, insert the following after the 'create object' line

xl.Visible = True 'this makes the excel process visible

and in the form onclick event put the following after the SaveAs line

xl.Application.Quit 'this quits the excel object you opened preventing the this file is already open scenario...

I'm afraid you'll have to shut down the computer to free up the files that are invisible....

 

[ecniv]

Hi

Bit late for me to post as you've already solved it but I wanted to chuck my 2 cents worth in.

Couple years back I wrote (in access VBA) a text file reader that read any text file into a table (max 50 fields per row) so the developer could then manipulate the data easier (queries into the right tables or a custom code loop to transfer into the right tables).

I could dig around for it if you are interested, it was in Dao... and may need to be tweaked


Vince

 

[MarionD]

Vince,

Hi would really appreciate it if you could find it!

Thanks
Marion

 

[MarionD]

Simply, thanks will enter the lines. My problem is then to extract the data out of this txt file.
thanks for your trouble!

Marion

 

[ecniv]

Hi,

I think this is all the bits you'd need. I would keep this separate and look through it at your leisure (perhaps use parts or the general idea in the future?)


Vince

 

[MarionD]

Thanks Vince!! Will let you know how I manage

 

[Steven811]

disable the pagedown function

Hi

In the db I have constructed, when I'm in a form and press the page down key the layout of the form is changed. This is not helpful and I wish to disable this capability, when in Access only.

How can I do this?

Steven811

 

[Steven811]

Sorry

Posted in the wrong bit, brains in the bin