automate import from excel or text file

[ouradmin]

I have an application that needs to have data imported from either Excel spreadsheet or .txt. How do I go about putting a button on a menu that can automate this process?

 

[CaptainD]

Have you tried linking to the Excel file or text file?

Then you do not need to import.

 

[ouradmin]

This is a database that I am looking at distributing to other organizations. Not sure how to link to the spreadsheet with too many unknown variables based on each user. I think importing would be more consistent.

 

[randy700]

How about the TransferSpreadsheet method?


Randy

 

[ouradmin]

I haven't used that. How do I do it and how do I incorporate it into a button on a menu?

 

[HarleyQuinn]

Not to sound unhelpful but have you looked n the help files for it?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.