SQL file

[mayajhon]

Hi,
I using Access Data base.
I have a table sent to me in SQL
how can I view it?
I also have MS sql server 7 I don't know if it can help.
Thanks

 

[NoCoolHandle]

do you have an example of what you mean?

is it a .sql file? what is the text inside it?
is it a backup file or maybe an mdf,ndf or ldf file??

Open whatever you have in NOtepad and do a copy paste from the first couple of lines to the body of your reply.

 

[mayajhon]

Thanks for your reply,
I have a sample file but when I open the file its not aligned correctly this is long record so it goes to the next line.
the first two lines are the header record and the rest are one record it's just long
file Name:AT009999.E242ABC9
COFHDRABC9999 2002052420020524COF2002052420020524 COFDTL00030836108 0166389 JCY 00000000000000 A/C 5370575812 5370575812 SMITH SHELLEY

sorry if I confused you,Thank You. Maya

 

[Katy44]

You maybe want to try copying it in Excel and delimiting using a space as your delimiter. You will then be able to import it into a SQL Server table if you need to.

 

[NoCoolHandle]

Have you tried changing the extension to cvs or txt and then importing directly into Access?