Using the Runtime - Get external data

[David Cleland]

Hi all,

I am creating a database using the runtime to make it stand alone. The
problem is my app uses the data importing from excel so I need the "get
external data" option.

Is there a way to include this ?

David

 

[Lynn Trapp]

2 ways.

1. Create a custom menu bar that includes the Get External Data choice
2. Create an ImportData procedure that is called from a form.... use
something similar to this depending on your requirements:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "YourTable",
"FileName"

 

[David Cleland]

Lynn,

I am sorry - I am teacher feeling his way on this - can you talk me through
the steps ?

David

 

[Lynn Trapp]

Sure. I would say that the simplest way is to create a custom Menu Bar and
attach it to some form that you have open.

1. Tools > Customize > Toobars tab > Click the New Button
2. Give your toolbar a name.
3. Select properties and change it to a Menu Bar
4. Click and Drag the Import... command to the new toolbar
5. Set it as the Menu Bar for your form on the Other tab of the Form
properties sheet.

 

[David Cleland]

Perfect that works a treat.

It is a bad thing when the teacher is weeks ahead of the pupils

David

 

[Lynn Trapp]

I'm glad it worked, David.

Well, it's better than if you were only a day ahead of them. Of course, the
way kids are with computers these days, it's a wonder that you aren't a few
days behind them...LOL

 

[David Cleland]

I am generally ok with Access but we bought the visual studio package and I
have to say I am putting myself through hell - I hope my macros have come
over.

It is ace though I love it.

David