Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aakcse
Aged Yak Warrior
570 Posts |
 Posted - 2009-03-10 : 10:35:49
|
| Hi all,I have a text file who's column header as below, I want to import this file normally.with column header in one line..header is as belowvend vendnumber name-------------------------------------------123 abc432 xyzI want to upload this type of file to access 2007 with header and content as belowvend number vend name123 abc432 xyzI am not getting any option in access to bring the 2 row col to one and remove the dotted line..kindly help.regards,aak |
|
|
guptam
Posting Yak Master
161 Posts |
Posted - 2009-03-11 : 00:49:35
|
| Is the data in fixed width format?-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/ |
 |
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-03-11 : 06:00:31
|
quote:
Originally posted by guptam
Is the data in fixed width format?-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/
|
|
|
|
aakcse
Aged Yak Warrior
570 Posts |
Posted - 2009-03-11 : 06:02:30
|
yes it is in fixed width formatquote:
Originally posted by aakcse
quote:
Originally posted by guptam
Is the data in fixed width format?-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/
|
|
|
|
guptam
Posting Yak Master
161 Posts |
Posted - 2009-03-11 : 10:14:14
|
| Then you can put it into Excel and transform it to how you want to column headings and then later import it :).Thanks.-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/ |
|
|
|
|
|
|
import issue