We get certain quarterly data in column-width format.. I hate having
tor respecify the file layout every time and we would make fewer
mistakes if it was stored somehow more programmatically.


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.facebook.com/vasjpan2
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos]

vjp2.at (AT) at (DOT) BioStrategist.dot.dot.com wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You don't state what you're doing - I'm assuming you're importing the
data. If so, you can use the Import Specification to save the file
format. Then use TransferText or TransferSpreadsheet or
TransferDatabase and the specification, depending on the file type you
are importing/linking, to import/link the data.

- From the main menu File > Get External Data > Import Data. An import
dialog box will appear - click the Advanced button. The Import/Link
specification dialog box will appear - set up the form and save the
specification. Close the dialog box and return to the import dialog
box. Either complete the import/link or cancel the action. Use the
saved, named specification w/ the Transfer... methods.

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSm0IlIechKqOuFEgEQLrZQCghdEGsa8Sbc306yDmnnt0Ub cmnW8AoOMh
YMUk5wt9Ft8s3KCxL6Cx0MUy
=/KQE
-----END PGP SIGNATURE-----

Thanks, When I was importing text I saw some chance to save the spec
(Schema.ini?) and then it said something about VBA..

Is there any way I can save the existing spec for future use?


*+-You don't state what you're doing - I'm assuming you're importing the
*+-data. If so, you can use the Import Specification to save the file
*+-format. Then use TransferText or TransferSpreadsheet or
*+-TransferDatabase and the specification, depending on the file type you
*+-are importing/linking, to import/link the data.

*+-- From the main menu File > Get External Data > Import Data. An import
*+-dialog box will appear - click the Advanced button. The Import/Link
*+-specification dialog box will appear - set up the form and save the
*+-specification. Close the dialog box and return to the import dialog
*+-box. Either complete the import/link or cancel the action. Use the
*+-saved, named specification w/ the Transfer... methods.

*+-HTH,


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.facebook.com/vasjpan2
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yes, as I stated in my previous post - use File > Get External Data >
Import [or] Link. After you select a file (any file text will do for
example purposes) click the "Advanced" button on the import/link dialog
box. This will bring you to the Import/Linked File Specification dialog
box. The "Specs..." button will show you currently saved
specifications. You can use one of those, or create your own & save it.

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSm/QzYechKqOuFEgEQKC5wCePeGJdi28aBWR6JxM2SDEm6872GQAn 25S
AxbAhBWOtHAzjPhZuQFd/ZyI
=O4oD
-----END PGP SIGNATURE-----

vjp2.at (AT) at (DOT) BioStrategist.dot.dot.com wrote: