Hi,
I am trying to email a table in text format using :
DoCmd.SendObject acSendTable, "Table", acFormatTXT, , , , "Results", "Attached are the reslts"
It sends the file in text file format, but it adds "-" & "|" characters all over the file. Is there a way that I can send the file in simple "Comma Separated" file format.
Thx,
Jatz
Hi,
I am trying to email a table in text format using :
DoCmd.SendObject acSendTable, "Table", acFormatTXt, , , , "Results", "Attached are the reslts"
It sends the file in text file format, but it adds "-" & "|" characters all over the file. Is there a way that I can send the file in simple "Comma Separated" file format.
Thx,
Jatz
I currently have a query pulling data from a database - I need to now export the data to a text file to import it into a different database. I need the format to be like below. Wondering how I can tell the query to go to the second line and then the third line like below.
*,9215146,BUILDERS LLC,4285 NICOLET,DALLAS,TX,75201
P,2
C,2,,BRD
Someone decided to be clever and send a text file with a stupid date format, is it possible to show off a little here and get a working date format, it's a text file I am working with: Dec 18 2014 01:12PM.
Not that is an exactly cut/paste so spaces are as they are here, ideally would like to get 18/12/14 13:12.
I am trying to find a way to extract an email from a large text file that is an output from our email system. I would like to be able to extract the email address using a query or collection of queries. I have been able to extract all of the text that contains the @ symbol. From their I created a query expression:
Mid([field1],InStrRev([field1]," ")) that captures some but not everything I need.
I have a table with below fields and content:
container_nr_no Type time
AAAA1233456 210 12:30
BBBB1222234 45g1 13:30
And I would like to generate a output text file like below:
FLD00101=1
FLD00102=AAAA1233456
FLD00103=210
FLD00104=1230
FLD00201=2
FLD00202=BBBB1222234
FLD00203=45G1
FLD00205=1330
FDL00.... should be generated automatically, starting with 101 for 1st container and 201 for 2nd and so forth. The output should be in vertical manner.
I want to export a table in access table .
1. for example every day at 8.00 it create an output excel file.
2. Attach the file and send to a fixed email at that time.
I upgraded to Access-2010 and the Text File Import function will not recognize dates in the format YYYY-MM-DD. The import dialogue sees enough to recognize the field as a date, but then every date encountered is written to the Import-Errors table. This is true whether the file has a .txt or .csv extension. The actual file format is .csv.
View 6 Replies View RelatedI have a CSV file and want to convert it in a text format with some filtered data and with some formatting. This is an everyday task for me. So I made a table and imported the data in to it by the command :
DoCmd.TransferText acImportDelim, "fo Import Specification", "fo", FileName:="C:UserswelcomeDesktopfo.csv", HasFieldNames:=True
Actually I have a column "SERIES", contains various series like "EQ", "BE", "DR", "BZ", "D1" and so on. And one more column with the dates having 4 / 5 current months dates and one next months date and one next to next month's date. And every date has got several thousand records.
now the issue is that : After importing these several thousand records, I want to export it but with a specific date and with a specific series.
The other thing is that, these dates change every month so if hard coded, the problem will occur the next month.
I use this code for export :
DoCmd.TransferText acExportDelim, "NewFnoSpec", "fnoquery", "C:UserswelcomeDesktopFO Output.txt", True
this code is working fine but when the month will change, the code won't work.
Can we have a date & series picker attached to this query, so it can export the records with the specified SERIES & DATE.
I tried putting a textbox on the form named TxtDate and in a Query ( Design mode ) under the date column, in criteria I have put [Forms]![Futures]![TxtDate] and after putting this line, the query becomes empty and no data is there.
I have some vba where I'm importing a text file and splitting it out into a table. For the most part its working just fine.
But I have a line of data that I need to pull out the string right after "Old" - Murphy and right after "New" ZMurphy
Acc# : 111111 This is test data, Person : 22222 Old Murphy New ZMurphy
I'm thinking Instr() could do this but I'm unable to get it to work.
I am using Access 2010...
Hi all,
I have a text source file and inpul layout i.e. field names start and end positions in excel file. I want create a table in access from the text data using excel file layout.
Can you please help me out in this. I am a mainframe programer and recieved an request to work in access.
We're using Access 2010 on Windows 7.We have a large database design where we send reports as e-mail attachments. We need to change the way the file is automatically created when sent. I goes to snapshot form every time we attach it to an e-mail. How can we get rid of the snapshot .snp file format? How can we change it to pdf or accbd?
View 3 Replies View RelatedI have a problem in converting the content of a simple table to a text format I need for an other program. The table is containing 3 columns
- ITEMID
- COLOR
- MINQTY
How do I convert the table to a text format with below format.?
ITEMTYPE is all ways >P<
How is this text shown. Do I make a kind of report.?
I have attached the two document (Text format and DB)
<INVENTORY>
<ITEM>
<ITEMTYPE>P</ITEMTYPE>
<ITEMID>3622</ITEMID>
<COLOR>11</COLOR>
<MINQTY>20</MINQTY>
[Code] .....
I have a link table that has a field that represents dates - but they are actually just text. It's a long story but the source is not going to change - so I have to try and deal with it. I need it to behave as a date - and am hoping to do this in a query. The data looks like this:
7/24/12
10/08/13
I have tried various things but it does not seem to totally do the trick - if I sort on it it still does not sort as one would expect from an actual date field. How do I do this?
How to read data in file (attached) and import data by reading certain amount of characters in a line like A02 and read 30 to 40 characters which has the Name of a passenger and may 20th to 25 has the name of an Airline. Import these data into a table with pre-assigned columns.
View 11 Replies View RelatedI'm trying to link a table to a massive 3GB text file so that I can generate a report. The text file is an exported Access query, so I can analyze the data in query form, BUT I'd like to analyze as a text file to confirm that nothing is altered during the export process. (e.g. Sometimes rounding errors can alter data, etc.)
Unfortunately, I'm getting an error saying that the text file is too big.
Hi, I'm trying to import a text file (just for a test at the moment) with the fields seperated by |'s.
The table I'm trying to import to has the fields -
ID, First Name, Last Name, Gender.
The ID is an autonumber though so what can I put there in the text file because I'm getting an error? :confused:
Hello - I want to import a text file into a table in a database. The text file looks like this:
00001 06006025 1420 0010 Health Insurance 7
00001 06006025 1425 0010 Life Insurance 7
00001 06006025 1430 0010 Disability 7
00001 06006025 1440 0010 Profit Sharing 7
There is no consistent delimiter. The text field is making things complicated because there is no accurate way to separate the text field from the last number in each line ('7') which needs to be stored in a different column.
Is there a way to insert quotations arond the text string so the quotation mark can be used to distinguish it when importing into excel or a database table. This may work because the starting position of the text string is constant. The ending position would have to be defined as the place where the number appears ('7' in this case). Then, quotations need to be placed around the text string.
Is this possible? Any advice will help tons!!!
I'm trying to figure out how to link a text file to my database with VBA. I know how to do this for other types of data sources, using the DoCmd.TransferDatabase acLink command, but need guidance using this with TXT files.
Thanks,
Randy
Hi,
I have a text file with comma separated values. What I want is a single access query to import this text file into an access table. I know this can be done through import text wizard in access - but what I need is a single query.
I have done the same thing for transferring oracle data to an access table - but for text file to access, I am getting -7778 error.
This is the query I have written
SELECT * into MY_ACCESS_TBL from [odbc;Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=MY_TEXT_FILE_PATH;].[MY_TEXT_FILE.txt];
Please help!!
Regards,
Suneesh
I have a small problem with the following command:
Code:
sTabNam = "TmpTab"
sFilNam = "C:Data.Txt"
DoCmd.TransferText TransferType:=acLinkDelim, TableName:=sTmpTab, FileName:=sFilNam, HasFieldNames:=True
The file C:Data.Txt contains 5 columns, separated by a semicolon with the first line containing the names of the columns. The concern is that when the linked table is created, I get a single column with all fields concatenated value. the following style :
Col1;Col2;Col3; : Column name
Val1;Val2;Val3; : Row value
What does do to have columns separated with the corresponding values?
I want to format the text using format function. how i format the word apple to "apple" (With Quatation mark).
str = Format(Me.word, xxxx)
I am trying to export a text file to be imported in to excel but whenever I export as fixed width all by number columns get cut to 2 decimal places, does anybody know how to get around this?
Thanks
When exporting a table from Access as a text file, it keeps adding .00 to the end of the number format records that I am tying to export.
Why it is doing that and what I need to do to prevent that from happening?
I have a table. Also i have a text file which some of the fields are matching with my table fields ( lets say field A and B ). Now, i need to do compare of these A & B of my table against A & B of the text file and give a result as follows;
1. "Field A" not in the table but in the text file (un-matching data to be shown )
2. "Field A" not in the text file but in the table (un-matching data to be shown )
3. "field B" mismatches
I have a table that contains a primary key and I am trying to append records from a text file. When I go to append the records, it tell me that XXX amount of records were lost due to key violations. Shouldn't access be able to figure out how to create new ID's on newly appended data?
Access 2007.