Hi,
I have a Make Table query that has the Date field as follows,
Date: IIf(IsNull([FSP date]),"",DateValue( (IIf(IsNull([FSP date]),"",Format([FSP date],"mm/dd/yyyy"))))).
Query run fine and creates the table, but when I try to export it to a txt file using the export wizard it fails and gives me the message that says, "Microsoft Jet Database could not find the object". Could somone please shed some light and tell me what am I doing wrong here !!
Thanks
1 1483
Hi,
I have a Make Table query that has the Date field as follows, - Date: IIf(IsNull([FSP date]),"",DateValue((IIf(IsNull([FSP date]),"",Format([FSP date],"mm/dd/yyyy")))))
Query run fine and creates the table, but when I try to export it to a txt file using the export wizard it fails and gives me the message that says, "Microsoft Jet Database could not find the object". Could somone please shed some light and tell me what am I doing wrong here !!
Thanks
Hi. Whatever is happening it is unlikely to be as a result of the date conversion and subsequent table export. Out of interest I tried a make-table that included a number of fields along with your string-converted date function. I exported the table to text with no problems.
You might wish to backup your database then try a compact and repair and see if your export difficulties continue.
Your string conversion for the date does not need to test for null twice: - Date: IIf(IsNull([FSP date]),"",DateValue((Format([FSP date],"mm/dd/yyyy"))))
-Stewart
ps the DateValue function is unnecessary too and can be left out altogether: - Date: IIf(IsNull([FSP date]),"",Format([FSP date],"mm/dd/yyyy"))
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: abhishek.srivastav |
last post by:
Hi
I m a new one in Db2 .I have a table which includes a varchar,date and
a clob column.I am trying to export all the columns at one go rather
than exporting the varchar and date type data once and then the clob
data . When doing this i;e exporting all the columns at one go,I m
getting the flat file of size Zero .No error is showing up in the
message file.The data just vanishes.
Someone please help
Thanks in Advance.
|
by: Fran Zablocki |
last post by:
I have a process that exports an Access table to a comma-delimited
text file. One of the fields that is exported shows the date it was
exported, using the Date() function. In the Access table, the date
appears in the records in mm/dd/yyyy format, but after exporting, the
date appears as mm/dd/yyyy 0:00:00. For example, today is 11/06/2003.
It shows 11/06/03 in the Access table, but the exported text file
shows 11/6/03 0:00:00. I thought...
|
by: D |
last post by:
I've created a report with many subreports of aggregate data. I want my
client to be able to export this data to Excel to make her charts, etc. Only
one problem: one of the fields is a "SchoolYear" TEXT field that contains
data such as 2000/01, 2001/02, etc. If I export a Query with this kind of
data to Excel, it gives me the text value of this field; however, when I
export a Report bound to this TEXT field, Excel gives me the values 36526,...
|
by: Big Time |
last post by:
I'm exporting a large amount of data from one of my tables into a tab
delimited text file. The problem is the fields that have date format come
out in MM/DD/YY HH:MM:SS format when what I want is to have the dates come
out simply as MMM/YY i.e. Jan / 04 instead of 1/1/04 00:00:00 . I have
tried using export specs to get this to work but there is no option to drop
the DD and have it export simply as Jan/04. Is there any way around this?
|
by: David P. Donahue |
last post by:
I'm re-writing an application in C# that was originally written in
Delphi 7. The heart of the application is a DataSet displayed in a
DataGrid.
One of the main functions of the previous application was to save the
data to a file (it was XML, but the format is unimportant) that can be
re-loaded into the DataSet at a later time. (The reason for this was
that the queries which populate the DataSet can take a while to run, and
people...
| |
by: czarbjones |
last post by:
Hey Gurus,
I'm trying to export a query (QueryDataExport) to a comma delim CSV file. The file name should look like this "C:\DSF_20061127_124211.csv" however it is exporting as "C:\DSF_.csv".
Also all of the text fields and header are being exported with quotes "" around them and I'm unsure how to turn this off. Do I have to actually have to create a rst and then code it to go through and remove these manually or is there a function...
|
by: sara |
last post by:
I have what I think is a little strange...I have to get data from our
payroll system into a specific format (fixed record length) as a .txt
or .prn file only to upload to our 401k custodian.
I can get the data into Access (from Payroll) and write a query with
all the fields (inserting fields with spaces, as needed), but I can't
figure out how to get it to export to a .txt file - without the field
name header row.
I don't really ...
|
by: pmatzek |
last post by:
I am attempting to automate a process involving importing a .txt file into an existing table, changing a date in each record, then exporting the table, again as a .txt file. One field contains a date (yyyy-mm-dd) and another a date/time (yyyy-mm-dd hh:nn:ss). If I do the export manually, the exported data in the .txt file is correct, but if I automate the process using the transfertext action and an export specification, the date field exports...
|
by: mamin |
last post by:
I have a table that I need to export out to a text fiel, without column headers. I also need to have the file name include currernt date. Can anyone help me? I'm using the following code:
Public Function CreateFiles()
Dim db As Database
Dim rst As Recordset
Dim m_str As String
Dim dt_str As String
Dim y_str As String
|
by: billelev |
last post by:
Hi there,
My question does not concern the exporting of data to CSV so much as the format of the exported data. The data to be exported consists of a time series of prices for a number of assets. I can easily bring up a query of the data I want to export in the following way:
SELECT Date, Asset, AssetPrices
FROM tblPrices;
returning:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |