Unix Technical Forum

newbie trying to import sybase file

This is a discussion on newbie trying to import sybase file within the Sybase forums, part of the Database Server Software category; --> Here's the situation: This compnay uses a Sybase database server running on NT. They have an Access application that ...


Go Back   Unix Technical Forum > Database Server Software > Sybase

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 03:41 PM
Tony Barnhill
 
Posts: n/a
Default newbie trying to import sybase file

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


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-08-2008, 03:41 PM
Anthony Mandic
 
Posts: n/a
Default Re: newbie trying to import sybase file

Tony Barnhill wrote:

> 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:37 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com