This may be a real dumb question but is there any way to view/edit an existing export specification for the transfer text macro? I'm reviewing someone else's database and can't figure out how to view it.
View RepliesHello,
Does anyone knows how can I export the export/import specifications (which file/directory) and how can I import/export the specifications between different versions of Access. Thanks!
I created a table with an older version of MS Access which was replaced with Access 2010. I was able to export the table simply by selecting specifications that I created.
How do I export with these same specifications in Access 2010 ?
I am trying to export a table (and possibly later a query) into a fixed width text file and I am not finding where to set the specifications. When I select Text File in the export tab, I only get the check box about Export datq with formatting and layout. Is that basically it? I do have the table set up with the correct widths for the fields.
An additional question:
This is a large table with 99 fields for a total width of 804 characters. Is there any limit for the six of a record for such an export?
Hi,
Someone asked me to create a databasestructure and denote the corresponding file specifications so that the file can be exported to another program. I actually have to confess that I do not have any idea what is asked from me. I guess I have to design a database with tables linked by relationships to create the databasestructure. But can anybody tell me what is meant by a file specification? The only thing which I can image what is meant are te data types (numbers, text and so on)...but I guess that is not correct...
Can anybody help me please?
Hi,
I am attempting to import a .csv file into Microsoft Access. The .csv file is a raw data export from an online application used within the business.
One of the fields reported on within the file is unformatted, ie. "free-text". Some users are entering a comma within this "free-text" field, which is throwing my import table out of alignment.
Is there some way that I can continue to import the .csv file, but ignore any commas that appear within this one field.
Any advice would be greatly appreciated.
Thank you.
I am using file/export and choosing XML but it won't work just get the error "can't export the data"
Can export to csv, xls etc
what do I need to do to export to XML?
I'm using access XP.
Thanks
When I export a query to xml (MS Access) then the name of the query equals
the tagname in xml. Example: when the queryname is ‘qryRegions’, the xml
result is:
<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata"
generated="2006-03-04T14:32:33">
<qryRegions>
<City>Woonplaats</City>
<ContactName>Naam</ContactName>
<Profession>Beroep</Profession>
<Phone>012-3456789</Phone>
<Province>Flevoland</Province>
</qryRegions>
</dataroot>
What I want to do is selecting one of the childNodes as firstChild e.g.:
<dataroot>
<Province>
<City>Woonplaats</City>
<ContactName>Naam</ContactName>
<Profession>Beroep</Profession>
<Phone>012-3456789</Phone>
</Province>
</dataroot>
I can’t find a way to manage this. Any suggestions??
Hi:
I want to automate the XML export function of Access and not sure if it is possible or how to do it. In going through the menu bar (File ->Export) interface, I must choose the root table, and then subsequent tabbed windows allow one to select what tables to be exported, if I want the schema to be generated, the target filename, etc.
Instead of having to go through this large selection process, I'd like to write a script that I can run consistently over the same tables, produce the same file name, etc. Can anybody provide a suggestion/code/pointer on how to accomplish this? Thanks in advance.
John
I have one workstation that errors when code get to a line where I try to export a report to an rtf file. The error message says something like 'Cannot execute export command'. It works on other workstations and I can even manually export the report to an rtf file - Any ideas?
Thanks,
Hey all,
I'm working on an invoice system in Access and I had just wondered if there was a way I could export a form to a format I could distribute to clients? (pdf, html...etc) thanks!
Ok I am exporting some data to a plain text file and one of the fields I am outputing can vary in the number of characters and I need they to have the same number of characters all the time.
Ex: 123.00 => 000012300
456789.00 => 045678900
I had heard of a command, but I can't remember what it was...I could do a loop till LEN() = 9 but that would cause undue clock cycles (aka performance hit) on the machine when running through the export routine.
This is a huge export of data.....
Thanks,
Richard
I'm trying to find a way to export the structure of a table in my Access database.
I created a new table and I want to put it in the database on my website. However, my site is constantly being used so I have no way of downloading the database, modifying it, and then uploading it again without losing some data.
I do have a database editor on my website that allows me to run queries. So If I can get a query with all of the CREATE TABLE information (all the fields, whether they are Allow Zero Length, etc.) then I can just use that.
I can't seem to find a way in Access 2000 to export the structure of the table.
Guys,
I have a list of account numbers.
A0010
N0103
C0123
etc. etc.
All in field in DB. called CLI_CLIENTCODE
I would like to output them into a text file as "A0010", "N0103", "C0123"
Background is that I have set up a DB that connects to an Oracle DB and where we have an email address for a client it emails a PDF file to that client.
Prior to this emailing we used Crystal and we will continue to do so for those without email, the format above is Crystal Filter and I can copy paste the above straight into a filter blocking them from creating a printed statement.
Your assistance would be appreciated.
Cheers,
Rob
Ok forgive me I'm a newb. I curently have a query in access that I'm trying to make a button to automatically send the results of this query to excell. When I run the code (below) it gives me a compile error saying user defined type not found on the highlighted portion
Private Sub ExporttoX_Click()
On Error GoTo Err_ExporttoX_Click
Dim db As DAO.Database
Dim rs As DAO.Recordset
'Set db = DAO.DBEngine.Workspaces(0).OpenDatabase( _
"C:database.mdb")
Set db = CurrentDb
Set rs = db.OpenRecordset("qbpexcel", dbOpenSnapshot)
'Start a new workbook in Excel
Dim oApp As New Excel.Application
Dim oBook As Excel.Workbook
Dim oSheet As Excel.Worksheet
Set oBook = oApp.Workbooks.Add
Set oSheet = oBook.Worksheets(1)
'Add the field names in row 1
Dim i As Integer
Dim iNumCols As Integer
iNumCols = rs.Fields.Count
For i = 1 To iNumCols
oSheet.Cells(1, i).Value = rs.Fields(i - 1).Name
Next
'Add the data starting at cell A2
oSheet.Range("A2").CopyFromRecordset rs
'Format the header row as bold and autofit the columns
With oSheet.Range("a1").Resize(1, iNumCols)
.Font.Bold = True
.EntireColumn.AutoFit
End With
oApp.Visible = True
oApp.UserControl = True
'Close the Database and Recordset
rs.Close
db.Close
End Sub
Any help would be apreaciated
Boy am I frustrated.
I have searched the forums for similar problem but I was unable to find it.
I have some buttons that export the data from a form into a Word Document. It generally works but there are some issues.
I have Access 2003 but the people using it only use the runtime version of Access and the environment is Office 2000.
I have copied code from other examples and maybe missing something that is causing the issues.
1. When I export the record it is causing problems with the Normal.dot template. When I try to close Word it keeps asking me that I have modified that template. After pressing Cancel button twice it the save box disappears.
2. When I leave the code Dim objWord As word.Application I get an error message about a compile error User defined Type not defined.
2. When the users try to export a record to the specific word template I
created and a required field is empty an error message is displayed and then closes the application.
Any help will be appreciated. I am a newbie when it comes to code.
Sample code is below.
Private Sub Command1079_Click()
Dim objWord As word.Application
'Start Microsoft Word 2000.
Set objWord = CreateObject("Word.Application")
With objWord
'Make the application visible.
.Visible = False
'path and name of the template your are using.
' objWord.Documents.Add ("U:Asset Strategy and Commercial PropertyCommercial PropertyTaskmasterletterofobjection.dot")
.Documents.Open ("C:Documents and SettingsDadMy DocumentsWorkTaskmasterletterofobjection.dot")
'This is for the bookmark that you created in the template
.ActiveDocument.Bookmarks("bmSubject").Select
Selection.Text = Forms![frmTaskMaster_LeaseManagement]![Subject]
.ActiveDocument.Bookmarks("bmCurrentRent").Select
.Selection.Text = Format(CCur(Forms![frmTaskMaster_LeaseManagement]![CurrentRent]), "Currency")
.ActiveDocument.Bookmarks("bmVendetails").Select
.Selection.Text = Forms![frmTaskMaster_LeaseManagement]![VenDetails]
.ActiveDocument.Bookmarks("bmDateNotice").Select
.Selection.Text = Format(CDate(Forms![frmTaskMaster_LeaseManagement]![RentNotice]), "dd mmmm yyyy")
.ActiveDocument.Bookmarks("bmRentReviewDate").Select
.Selection.Text = Format(CDate(Forms![frmTaskMaster_LeaseManagement]![ReviewDate]), "dd mmmm yyyy")
.ActiveDocument.Bookmarks("bmAskingRent").Select
.Selection.Text = Format(CCur(Forms![frmTaskMaster_LeaseManagement]![AskingRent]), "Currency")
End With
Print_Reconsideration_Err:
'If a field on the form is empty, remove the bookmark text, and
'continue.
If Err.Number = 94 Then
.Selection.Text = ""
Resume Next
End If
objWord.Application.Options.PrintBackground = False
objWord.Application.ActiveDocument.PrintOut
End Sub
I can export my reports to rtf, but the lines and other stuff on my reports dont show up.
How can i fix it to show everything on the report.
I am having problems export a queries results. That is, all I am trying to do in use the File, Export function manually, BUT I am not able to select it. ANy thoughts?
Thanks
I need to export ms access table to dbase III format.
When I use export something is missing and the file format
is just not good.When I try to open dbf file with
program Dbase I get message "not a dbase database".
I find out that excel do the same, so if anybody know
how to export to dbase III using ms access or ms excel
please help.Ms access help is to install borland database,
I downloaded some from Internet but I don't know what to do with it.
PS: Even when I import dbase III file and try to export it back
there is a problem.
Please, please help.
Dear All:
I have a query with Student ID numbers. These numbers are listed vertically.
I wish to export these numbers as a csv file where there are commas after every Student ID number while keeping the vertical format.
Any ideas?
Thanking in advance.
Dion
I have a table of applications (200 applications), with the following columns for each application:
AppName
Description
BusCrit
BU
NumUsers
I need to export this to an excel spreadsheet into specific rows and columns and then save the spreadsheet, with it named for the application (ie, App1.xls) which it should get from the AppName column in the table. How would I do this?
hi all,
i found this forum recently and always seem to find my answers on it, this is the first time i havent.. so. firstly i am using access '97 (work is soon to upgrade to 2003 - finally).
my problem is
i'm trying to export a query to txt file, which i'm doing by
DoCmd.TransferText acExportDelim, eParcelSpec, "QryeParcelExport", "G: est.txt", False
the eParcelSpec i had to make via importing a text file, then on import text wizard, chose advanced, setup my field dilemeter to * and text dilemeter to none. this is saved and i can open it up going through the above process.
however when my docmd runs i still get the standard output with "fieldvalue" , "fieldvalue2". instead of the * and no comma
its important for this to be the other delimeters, as the exported file is going to be used in a posting company's program that requires a certain format to import shipping address information.
also, is there anyway to add lines to before the data is exported? i need to have a start of file and end of file characters before any data and after the data.
thanks guys
I'm trying to find a way to export the structure of a table in my Access database.
I created a new table and I want to put it in the database on my website. However, my site is constantly being used so I have no way of downloading the database, modifying it, and then uploading it again without losing some data.
I do have a database editor on my website that allows me to run queries. So If I can get a query with all of the CREATE TABLE information (all the fields, whether they are Allow Zero Length, etc.) then I can just use that.
I can't seem to find a way in Access 2000 to export the structure of the table.
The database on my website is also Access 2000.
Hi,
I used this way to export data to Excel worksheets, and do some formatting on the Excel sheet
Set objXL = CreateObject("Excel.Application")
objXL.Application.Workbooks.Add
Set objActiveWkb = objXL.Application.ActiveWorkBook
................
It works fine. I have a question.
When I run the function, suppose it takes 15 mins to export data because there are many records and calculations. During the 15 mins, if the user open the Excel file, it will break the process of export data to Excel from MS Access. So, how can I prevent the user break the process/prevent the user to open Excel worksheet?
I am making a database that will run the administrative part of a government run foreign teacher recruiting division.Running Office 2013 (and yes, it is overly bright), have used 2003,2007, 2010...I need to do mail merges, with lots of different sql's and templates. I have been using Albert Kallal's method and it works well.
However, some of my data is in THAI. And (I think) because this method exports to a .txt file first (.888) the data gets lost and shows as question marks.
Manual merge works fine.if I could export to xls in stead of .txt and use that as my merge source, that would work fine, but what part of the code would have to be changed.
Basically:
- export to xls in stead of the .888 file
- use the xls file as a datasource for the merge
hi,
I'm having a small but annoying problem exporting data to excel and then importing it back..
The problem is that when i export a table to Excel - it changes the date format from dd/mm/yy (which is what i have in Access) to DD-MMM-YY (automatically in Excel)
This proves to be a problem because when i import the spreadsheet back Access gives me a data type conversion error.
Its easily solved manually by changing the field in excel to dd/mm/yy format but annoying as the user will have to do this everytime they export and import!
Any suggestions??
Thanks in Advance..