dbTalk Databases Forums  

newbie trying to import sybase file

comp.databases.sybase comp.databases.sybase


Discuss newbie trying to import sybase file in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tony Barnhill
 
Posts: n/a

Default newbie trying to import sybase file - 07-07-2003 , 09:38 AM






Here's the situation:

This compnay uses a Sybase database server running on NT. They have an
Access application that takes that data and converts it into reports. I
didn't do any of this, so that's why I'm a little confused. I have a .log
file that a backup .bat file made. This .bat file was created by the same
person who made the Access side of things. I have an 87MB .log file now and
I need to figure out how to get to the data that's inside of it so that i
can import it into my Access tables.

thanks in advance,

Tony Barnhill



Reply With Quote
  #2  
Old   
Anthony Mandic
 
Posts: n/a

Default Re: newbie trying to import sybase file - 07-07-2003 , 10:55 PM






Tony Barnhill wrote:

Quote:
This compnay uses a Sybase database server running on NT. They have an
Access application that takes that data and converts it into reports. I
didn't do any of this, so that's why I'm a little confused. I have a .log
file that a backup .bat file made. This .bat file was created by the same
person who made the Access side of things. I have an 87MB .log file now and
I need to figure out how to get to the data that's inside of it so that i
can import it into my Access tables.
From your description, it sounds like the .bat file creates a
database dump. If that's the case, you won't be able to read
it with Access. check the .bat or post it for someone's opinion
here. Access can use ODBC to connect to a Sybase ASE server.
It should also be able to import CSV files that you could
create by using bcp to extract data from the ASE server.

-am © 2003


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.