28 million results in Google.
Zero real world solution (that I could find)
I would like to import a file spec from Access into Excel
I cannot figure out how.
Thank you for any direction you have for me.
Michael
How to import file specs from access to excel
-
- 4StarLounger
- Posts: 573
- Joined: 10 Feb 2010, 17:32
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to import file specs from access to excel
Can you explain what you mean by "importing a file spec"?
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 573
- Joined: 10 Feb 2010, 17:32
Re: How to import file specs from access to excel
I have a text file which is fixed width ( about 50+ fields)
The first time I import the file into Access I create a file spec using the specs supplied by the file creator.
I save it in Access as an Import specification so I can use it to import the text file in the future.
We are moving away from Access, so I need a way to import the text files into Excel without having to re-invent the wheel.
I want to be able to import the text file into Excel without having to rewrite the Import Specs.
Thank you !
Michael
The first time I import the file into Access I create a file spec using the specs supplied by the file creator.
I save it in Access as an Import specification so I can use it to import the text file in the future.
We are moving away from Access, so I need a way to import the text files into Excel without having to re-invent the wheel.
I want to be able to import the text file into Excel without having to rewrite the Import Specs.
Thank you !
Michael
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to import file specs from access to excel
Access stores its import and export specifications in two hidden system tables:
MSysIMEXSpecs lists the specifications with their general settings.
MSysIMEXColumns lists the settings for each column of each specification.
In theory, you can export these two tables to Excel, but unfortunately, Excel wouldn't know what to do with them.
You might use them as documentation, but basically, you'll have to reinvent the wheel...
P.S. Why are you moving from Access to Excel?
MSysIMEXSpecs lists the specifications with their general settings.
MSysIMEXColumns lists the settings for each column of each specification.
In theory, you can export these two tables to Excel, but unfortunately, Excel wouldn't know what to do with them.
You might use them as documentation, but basically, you'll have to reinvent the wheel...
P.S. Why are you moving from Access to Excel?
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 573
- Joined: 10 Feb 2010, 17:32
Re: How to import file specs from access to excel
I am the only person in my division that has used Access since I started in 1998.Why are you moving from Access to Excel?
Our IT department stopped supporting Access many years ago, and basically depend on me to handle it on my own.
Are you ready for this?
I am retiring in about a year and they are not "backfilling" my position.
The suits figured since "everyone" knows how to use Excel, they want to convert all databases (1,000s+) by the time I leave.
Crazy.... but true story.
Michael
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: How to import file specs from access to excel
Ouch! That's a fine mess they have gotten themselves into!
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 536
- Joined: 27 Jun 2021, 10:46
Re: How to import file specs from access to excel
They'll almost certainly live to regret that!
-
- 4StarLounger
- Posts: 573
- Joined: 10 Feb 2010, 17:32