Export/Import Table Specification

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I am using Access 2002 and I need to establish a table specification
and the instructions are:

"" go to the FILE/Save As-Export selection and
create a specification ""

This option does not appear so I am obviously missing a step.

Here are the steps that I have used:

i) select the table with the specification that I need;

ii) File > SaveAs

iii) the dialogue box does not include an export option.

Thanks,

Robin Chapple
 
Robin Chapple said:
I am using Access 2002 and I need to establish a table specification
and the instructions are:

"" go to the FILE/Save As-Export selection and
create a specification ""

This option does not appear so I am obviously missing a step.

Here are the steps that I have used:

i) select the table with the specification that I need;

ii) File > SaveAs
Click to expand...

No. Choose File > Export...
In the Export to dialog, choose the file type in the save as type dropdown.
Enter a filename, and click on Export.
The export wizard will start. At some point click on Advanced button, then
Save As, and give your specification a name.
 
No. Choose File > Export...
In the Export to dialog, choose the file type in the save as type dropdown.
Click to expand...

I accepted the default *.mdb
Enter a filename, and click on Export.
Click to expand...

I navigated to the file where I need the specification.
The export wizard will start.
Click to expand...

The export wizard did not start so I'm still missing something.
At some point click on Advanced button, then
Save As, and give your specification a name.
Click to expand...

Thanks,

Robin Chapple
 
Robin,

1. Open the database window
2. Select the table you want to export data from.
3. Click on File - Export
4. In the dialog that appears, pick any folder to save to then enter some
arbitrary name such as Robin.
5. Change the "Save As File Type" to Text Files
6. Click the Export Button
7. The Export Wizard Window appears, click the Advanced button
8. Set all the settings you need
9. Click the Save As button
10. Enter the specification name you want to use
11. Press OK
12. You can press the Specs... button to see your specification has been saved
13. Close
 
Hi Robin,

Robin Chapple said:
dropdown.

I accepted the default *.mdb


I navigated to the file where I need the specification.
Click to expand...

Aha, so what you are trying to do is to transfer the spec from one mdb to
another? If so, then open the second mdb. Use File, Get External Data,
Import and navigate to the mdb with the spec. Once the import dialog shows
up, don't click any objects, but click on Options and put a check beside
import/export specs.
 
Joan,

G'day from down under,

Thanks for your help,

Aha, so what you are trying to do is to transfer the spec from one mdb to
another? If so, then open the second mdb. Use File, Get External Data,
Import and navigate to the mdb with the spec. Once the import dialog shows
up, don't click any objects, but click on Options and put a check beside
import/export specs.
Click to expand...

I have been presented with an error message:

"" Not all of the import specifications could be imported due to name
conflicts. Conflicts existed in 2 of the specification ""

Now I don't know which names it refers to. If it is field names I cant
see any duplicates.

Here is the field list:

===========Start of Field List==========
Name
ID
UserName
Password
Title
FirstName
NickName
LastName
Office
Club
ClubWeb
District
DistrictWeb
EmailConsent
Email
Address
City
State
PostCode
Country
Phone
Fax
ICQ
PHF
MPHF
Benefactor
Bequest
SpName
SpRotarian
Vocation
Hobbies
PicFile
Joined
BornMonth
Bornday
BornYear
SpBornMonth
SpBornDay
SpBornYear
WedMonth
WedDay
WedYear
ROTIORG
Serious
ROTIWiz
ROTIGer
RotiLat
=======End of Field List===================

Thanks,

Robin Chapple
 
Hi Robin,

It's referring to specification names, not field names.

How many specifications exist in database 1 (the one you are importing
from)? What are their names?

How many specifications are in database 2 (the one where you want the spec
to be)? What are their names?
 
Joan,

There are no specifications that I am aware of. Where do I find them?

"" Help "" was no help.

Robin
 
Hi Robin,

Go to File, Export
In the Export to dialog, choose the file type in the save as type dropdown.
Enter a filename, and click on Export.
The export wizard will start. At some point click on Advanced button, then
Save As, and you'll see a list of the saved specifications.
 
G'day Joan,

I have not followed your instructions properly.

Go to File, Export
In the Export to dialog, choose the file type in the save as type dropdown.
Enter a filename,
Click to expand...

I was not sure which file type I should select.
and click on Export.
The export wizard will start. At some point click on Advanced button, then
Save As, and you'll see a list of the saved specifications.
Click to expand...


I did not see a list.

I have placed the screen grabs here:

http://www.rotary9790.org/test.htm

in the hope that this will explain better than words of mine.

Thanks,

Robin
 
Hi Robin,

The type of file you choose would depend on the type of file involved.

Just what is this export spec to do? Export information from a table? a
query? to what?

Usually this is an Excel file, a text file, another mdb... Where are you
trying to export your information?

Your screen shots suggest you want to export to a text file. Is that right?
 
Joan,

This all started when I tried to automate the import of a CSV file to
a membership database.

I was told that I needed a specification of the target table which is
what I am attempting before progressing to the import of the CSV file
on a regular basis.

The choice of text file was quite random because I do not know what I
am doing.

Robin
 
Hi Robin,

Thanks for this. As I understand it, you want to set up a specification to
import a CSV file.

From previous postings though, it appears that you already have a
specification set up, and it is conflicting with your current attempts.

I would suggest you delete all existing specifications and start from
scratch.
Backup your mdb.

In your mdb, go to File, Get External Data, Import.

In the Import dialog, choose Text (which includes CSV files).

Navigate to the location of your text file, and select it, and click on
Import

At the first step of the wizard, click on Advanced, and then Specs. You
should get a list of existing specs in the mdb. Select each one and delete
it, so that the list is empty.

Click on Cancel, and then OK and you'll be back at step 1 of the wizard.

Go through each step of the wizard, setting up the import.

At the last step, before hitting Finish, click on Advanced, then Save As...

It will suggest a name for the specification, but enter whatever you like
(be sure to remember/write down the name).

This is the specification name you would use in your code.
 
Back
Top