473,574 Members | 2,701 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Import (1) Text File with (3) different Header Records (3)Different Tables

31 New Member
I have moved this question to the correct forum..
Nov 15 '10 #1
1 1136
Wayne L
31 New Member
Sorry folks looks like I posted this in the wrong forum..
Nov 15 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
3492
by: DF | last post by:
Hello, We have a query which returns ~2.8 million rows. This same query is used in a DTS package, which exports to a text file. The number of rows in this text file, however, is ~2.7 million rows (I'm rounding of course.) So a good chunk of data vanished in the export it appears. Using SQL Server 7.0 on Windows 2000. Anyone see bugs...
4
8465
by: Kevin Forbes | last post by:
Hi there, When importing a text file using SQL Server, how do I specify the path to a file on the same remote server that SQL Server is running on? I tried //c:/filename but that doesn't seem to work. Also, once the import is working, how do I write a DTS package to first delete all rows in a table, then repopulate with the text file, or...
4
12685
by: news | last post by:
Our production database in an exported textfil runs about 60 MB. Compressed that's about 9 MB. I'm trying to import the export into another machine running FC3 and mySQL 11.18, and it appears as though the file may be too big! When I try to do it via command line: mysql -u root --host=localhost printing < ./printing.txt It eventually...
2
1304
by: Raghavendra Mahuli | last post by:
Hello, I have a text file in which records are stored in a particular format. For ex: Node1( att1, att2, node2(attx)) I need to convert it to xml. I know xsl can be used to convert *xml to* some other format. But i need the reverse operation. Same thing in xml has to be transformed to something like(need not be
3
2540
by: Daron | last post by:
I am using this command to import text file: DoCmd.TransferText acImportDelim, str_SpecName, str_TblName, str_FileName, False - The import will always be missing the first line in the text file. - These text files are coming out of Access. - The first line is formatted exactly the same and end with the same CR/LF that the rest of the...
3
20579
by: tjuiowa | last post by:
Hi I am trying to import a text file into a MS Access database. The first 11 lines of the text file are in a different format, so i would like to skip those lines and start at line 12. is there a quick and easy way to skip lines using VB in Access. Here is a sample of my text file: SDS 2.2 AD Results 1.0 Filename PlateID Assay...
3
1322
by: voroojak | last post by:
I have a bog problem in access what i have to do is that i have a text file that i have to insert it into access. but the problem is that there is two differnt type of data in my text file. the one that have rpt:1 have differnt format of those who hast rpt:2. but they are all in one text file. what i want to di is that i want to say that when...
1
987
by: nussu | last post by:
Hi, I have two pages. First page is login.aspx,second is deatils.aspx. When i enter different credentials in loginpage i need to get different headers in details.aspx page. For example if i enter login id and password as stud and stud i need to get one header in details.aspx and if i enter as emp and emp i need to get different header in the...
6
3387
by: =?Utf-8?B?emFsZHk=?= | last post by:
Hi! I have a question.. How can csharp read a text file and execute it in another application? What I mean is that, Im doing a drawing using Tekla Structures. But instead of doing the same thing over and over again, I want to create an exe file that allows it to read a text file and execute it in Tekla Structures. All I can do now is to...
2
2065
by: Wayne L | last post by:
I am not sure on how I should approach this. I know a loop but I am a newbee on this..I have one file that contains 3 seperate header records that contain data under each header. (AA AA) (AA BB) (AA CC) What I want to do is loop thru the data under each header data. I am using ACCESS 2000 and have import Specs for each one. (AA AA)Data in...
0
7735
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8065
Oralloy
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. ...
0
8246
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7823
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8102
tracyyun
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...
0
6458
agi2029
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...
0
3742
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...
1
1348
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1063
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.